# Database not working after upgrading to 8.1 from 7.9 **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [January 27, 2022, 5:48pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450 "2022-01-27T17:48:16Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 5:48pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/1 "2022-01-27T17:48:17Z")
I am using the same connections for my database as before but 8.1 won’t connect. Here is the error report. I tried creating a JTDS as a connection (saw this in the forum) but it did not help. All my settings are exactly the same as before and I even backed up the old and restored to the new version. java.sql.SQLException: 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’)) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:656) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:534) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:734) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:299) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:252) at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1096) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:582) at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.base/java.util.concurrent.FutureTask.runAndReset(Unknown Source) at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.base/java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: 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’) 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 java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source) 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.dbcp2.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:52) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:357) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:103) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:652) … 12 more Caused by: 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’) at com.mysql.jdbc.ConnectionImpl.buildCollationMapping(ConnectionImpl.java:1007) … 28 more 8.1.13 (b2021122109) Azul Systems, Inc. 11.0.13 ---
**Author:** ![pkhoshroo](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pkhoshroo/32/26801_2.png) [@pkhoshroo](https://forum.inductiveautomation.com/u/pkhoshroo)\ **Post date:** [January 27, 2022, 5:57pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/2 "2022-01-27T17:57:44Z")
> [@Cannot create PoolableConnectionFactory (Communications link failure)](https://forum.inductiveautomation.com/t/cannot-create-poolableconnectionfactory-communications-link-failure/47280/2): > > That means Ignition never even got to submit any username, as the database isn’t listening. If the DB is on a separate machine, you need to configure MySQL to listen to more than just localhost. After you fix that, you will certainly need to ensure Ignition is using a user name and password that exists in your database. Make sure to follow the steps above and it is better to create another user login and try again if you haven't done that already. ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 5:59pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/3 "2022-01-27T17:59:41Z")
Same machine. Same configuration. I am working with them on my laptop. ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 6:03pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/4 "2022-01-27T18:03:04Z")
I even went back to the university instructions twice to verify I wasn’t missing something even though it was working before. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [January 27, 2022, 6:05pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/5 "2022-01-27T18:05:49Z")
What database are you using? MySQL? ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 6:07pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/6 "2022-01-27T18:07:37Z")
Yes with the MySQL ConnectorJ same as before. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [January 27, 2022, 6:08pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/7 "2022-01-27T18:08:05Z")
Try making a new connection with MariaDB as the JBDC driver. ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 6:08pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/8 "2022-01-27T18:08:51Z")
I do not have that one how do i set it up and can you show screen shots if possible. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [January 27, 2022, 6:10pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/9 "2022-01-27T18:10:49Z")
It should come out of the box with Ignition 8.1 In your gateway → Config page → Databse → Conenctions → Create new Database Connection and you should see this ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/d/2d249e1ae9809d1281187e5722e5c24b98e4e205.png) Select MariaDB, enter your db credentials and see how that goes. You can try remaking with the MyQL driver if you haven’t already, but if that doesn’t work try again with the MariaDB driver. ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 6:14pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/10 "2022-01-27T18:14:51Z")
It did not come with the 8.1 version. Not with the install i downloaded from Ignition today. 8.1.13 for windows x64. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [January 27, 2022, 6:17pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/11 "2022-01-27T18:17:34Z")
My fault I thought it did. Here’s a tutorial - [Installing MariaDB - Connecting to Databases](https://inductiveuniversity.com/videos/installing-mariadb/8.1) I use MySQL and ended up needing to use it for the connection to work right. ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 6:21pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/12 "2022-01-27T18:21:53Z")
So let me add more info that might help apparently. I am using windows 7 and Maria won’t work on anything but Windows 10. So will 8.1 even work correctly on Windows 7? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [January 27, 2022, 6:22pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/13 "2022-01-27T18:22:33Z")
What version of MySQL are you using? ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 6:23pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/14 "2022-01-27T18:23:39Z")
8.0.28 ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 27, 2022, 6:38pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/15 "2022-01-27T18:38:38Z")
You need to manually update the JDBC driver. For backwards compatibility reasons, Ignition ‘trusts’ the JDBC drivers contained in a gateway backup over the ones installed on the system, even if the ones on the system might be newer. We cannot bundle MySQL’s JDBC driver directly, but a fresh install of 8.1.X _that has not had a .gwbk restored_ should have a newer version of the MariaDB driver file available, or you can download it yourself. MariaDB’s driver should be compatible with your MySQL version and a drop-in replacement. [https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators#JDBCDriversandTranslators-JDBCDriversandIgnitionUpgrades](https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators#JDBCDriversandTranslators-JDBCDriversandIgnitionUpgrades) ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 6:41pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/16 "2022-01-27T18:41:28Z")
I have windows 7 and Maria doesn’t like anything less than 10 when I try to install it. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 27, 2022, 6:44pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/17 "2022-01-27T18:44:52Z")
You don’t need to install MariaDB. You need a copy of the MariaDB (or MySQL) _JDBC driver_. > **[About MariaDB Connector/J](https://mariadb.com/kb/en/about-mariadb-connector-j/)** > > LGPL-licensed MariaDB client library for Java applications. [https://dev.mysql.com/downloads/connector/j/](https://dev.mysql.com/downloads/connector/j/) ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 6:46pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/18 "2022-01-27T18:46:44Z")
Do you have a screenshot of the connection setup? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 27, 2022, 6:48pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/19 "2022-01-27T18:48:43Z")
Follow the steps here: [https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators#JDBCDriversandTranslators-UpgradeaJDBCDriver](https://docs.inductiveautomation.com/display/DOC81/JDBC+Drivers+and+Translators#JDBCDriversandTranslators-UpgradeaJDBCDriver) Or get in contact with support, they can help guide you through the process. ---
**Author:** ![christopher.raphael](https://avatars.discourse-cdn.com/v4/letter/c/65b543/32.png) [@christopher.raphael](https://forum.inductiveautomation.com/u/christopher.raphael)\ **Post date:** [January 27, 2022, 6:49pm UTC](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450/20 "2022-01-27T18:49:35Z")
I have been to this website and downloaded the .msi file but it won’t install because of windows 7. There is a link to get .jar files but it directs you to a .msi file. [Next page](https://forum.inductiveautomation.com/t/database-not-working-after-upgrading-to-8-1-from-7-9/55450.md?page=2)