MySQL 8 on Ignition 8.1 [Solved]

Hello, I'm having problems with my current database setup. I have 8.1 installed and as for mysql i currently installed the latest which is MySQL 8.

My current mysql

mysql Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

When I tried to create a new database I got this error

Cannot create PoolableConnectionFactory (java.lang.ClassCastException: class java.math.BigInteger cannot be cast to class java.lang.Long (java.math.BigInteger and java.lang.Long are in module java.base of loader 'bootstrap'))

Any idea how to fix this? I think I've tried almost everything, my last issues were I had to change to a native password because of granting issues etc. And this was the latest issue I'm having. At this point I want to just switch to 5.6 but I also want to be able to fix this issue.

Thank you

I think you may just need to update the JDBC Driver in Ignition.

https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators

2 Likes

This worked. Thank you!