# MySQL database faulted! **URL:** \ **Category:** General Discussion\ **Created:** [June 11, 2018, 3:04pm UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398 "2018-06-11T15:04:23Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![anuragrattan23](https://avatars.discourse-cdn.com/v4/letter/a/f475e1/32.png) [@anuragrattan23](https://forum.inductiveautomation.com/u/anuragrattan23)\ **Post date:** [June 11, 2018, 3:04pm UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/1 "2018-06-11T15:04:23Z")
Hi guys! My database connection is faulted. It never worked. I am attaching the error details. Any suggestions please ! org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:242) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:196) at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer$1.run(DatasourceManagerImpl.java:1014) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:565) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1062) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3556) at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2513) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2283) at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:822) at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47) at sun.reflect.GeneratedConstructorAccessor47.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:404) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:317) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1247) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221) … 12 more Caused by: java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1007) … 27 more 7.9.8 (b2018053113) Oracle Corporation 1.8.0\_171 ---
**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\ **Post date:** [June 11, 2018, 3:07pm UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/2 "2018-06-11T15:07:41Z")
Are you using the newest version of the connector? ---
**Author:** ![anuragrattan23](https://avatars.discourse-cdn.com/v4/letter/a/f475e1/32.png) [@anuragrattan23](https://forum.inductiveautomation.com/u/anuragrattan23)\ **Post date:** [June 11, 2018, 3:11pm UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/3 "2018-06-11T15:11:21Z")
Yes, I believe this is the newest version. ---
**Author:** ![anuragrattan23](https://avatars.discourse-cdn.com/v4/letter/a/f475e1/32.png) [@anuragrattan23](https://forum.inductiveautomation.com/u/anuragrattan23)\ **Post date:** [June 11, 2018, 3:15pm UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/4 "2018-06-11T15:15:10Z")
This is the message in details- Databases / Connection [MySQL] Cannot create PoolableConnectionFactory (java.lang.ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long) ---
**Author:** ![anuragrattan23](https://avatars.discourse-cdn.com/v4/letter/a/f475e1/32.png) [@anuragrattan23](https://forum.inductiveautomation.com/u/anuragrattan23)\ **Post date:** [June 11, 2018, 3:16pm UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/5 "2018-06-11T15:16:43Z")
And he connector- mysql-connector-java-5.1.23-bin.jar ---
**Author:** ![ethomason](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ethomason/32/43338_2.png) [@ethomason](https://forum.inductiveautomation.com/u/ethomason)\ **Post date:** [June 11, 2018, 3:34pm UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/6 "2018-06-11T15:34:48Z")
Which version of MySQL Server are you trying to connect to? ---
**Author:** ![anuragrattan23](https://avatars.discourse-cdn.com/v4/letter/a/f475e1/32.png) [@anuragrattan23](https://forum.inductiveautomation.com/u/anuragrattan23)\ **Post date:** [June 13, 2018, 10:22am UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/7 "2018-06-13T10:22:28Z")
Its version 8.0.11. Also, I’m using Mac if that creates any difference. Thanks ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [June 13, 2018, 11:25am UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/8 "2018-06-13T11:25:19Z")
You'll need an updated JDBC driver and some extra connection properties: > [@Problems connecting Ignition to MySQL](http://forum.inductiveautomation.com/t/problems-connecting-ignition-to-mysql/18175/2): > > This is an issue with the bundled JDBC driver (MySQL 8 changed enough things that it broke backwards compatibility). A new version of the driver will be in new installs in 7.9.9, but in the short term you can install ConnectorJ from MySQL directly: [https://dev.mysql.com/downloads/connector/j/](https://dev.mysql.com/downloads/connector/j/) and install it on your system (refer to [this page](https://docs.inductiveautomation.com/display/DOC79/JDBC+Drivers+and+Translators) for more info). At a minimum, you’ll need to change the default ‘Extra Connection Properties’ to have zeroDateTimeBehavior=CONVERT\_TO\_NULL; and probably al… ---
**Author:** ![anuragrattan23](https://avatars.discourse-cdn.com/v4/letter/a/f475e1/32.png) [@anuragrattan23](https://forum.inductiveautomation.com/u/anuragrattan23)\ **Post date:** [June 13, 2018, 11:55am UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/9 "2018-06-13T11:55:14Z")
Hi Kevin, thanks for the suggestion. But I am still not able to connect the database. ---
**Author:** ![R.Alamsha](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@R.Alamsha](https://forum.inductiveautomation.com/u/R.Alamsha)\ **Post date:** [June 29, 2018, 6:09am UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/10 "2018-06-29T06:09:56Z")
> [@anuragrattan23](#): > > Its version 8.0.11. Also, I'm using Mac if that creates any difference. Thanks uninstall version 8.0.1 completely and delete any left over files and folders. Install 5.7.x. It will work perfectly. ---
**Author:** ![arun1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arun1/32/79753_2.png) [@arun1](https://forum.inductiveautomation.com/u/arun1)\ **Post date:** [January 18, 2019, 9:26pm UTC](https://forum.inductiveautomation.com/t/mysql-database-faulted/18398/11 "2019-01-18T21:26:22Z")
Can confirm, above solution by @R.Alamsha works