MySQL connectivity problem

Ignition
1

I am unable to connect to MySQL. I get the following faults:

Cannot create PoolableConnectionFactory (java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long)

org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long)

java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long

2

What version of Ignition are you using? Is it a “fresh” install?

You need to either upgrade your installation, or at minimum your JDBC driver: https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/125/0/connection-errors-when-configuring-mysql-80-database-in-ignition

3

version 7.8.5 (b2016120813)