# MySQL connectivity problem

**URL:** <https://forum.inductiveautomation.com/t/mysql-connectivity-problem/20323>\
**Category:** Ignition\
**Created:** [October 23, 2018, 3:45pm UTC](https://forum.inductiveautomation.com/t/mysql-connectivity-problem/20323 "2018-10-23T15:45:38Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\
**Post date:** [October 23, 2018, 3:45pm UTC](https://forum.inductiveautomation.com/t/mysql-connectivity-problem/20323/1 "2018-10-23T15:45:38Z")

</div>

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

---

<div class="post-metadata">

**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:** [October 23, 2018, 3:55pm UTC](https://forum.inductiveautomation.com/t/mysql-connectivity-problem/20323/2 "2018-10-23T15:55:48Z")

</div>

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](https://support.inductiveautomation.com/index.php?/Knowledgebase/Article/View/125/0/connection-errors-when-configuring-mysql-80-database-in-ignition)

---

<div class="post-metadata">

**Author:** ![pdixon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pdixon/32/6899_2.png) [@pdixon](https://forum.inductiveautomation.com/u/pdixon)\
**Post date:** [October 23, 2018, 4:28pm UTC](https://forum.inductiveautomation.com/t/mysql-connectivity-problem/20323/3 "2018-10-23T16:28:43Z")

</div>

version 7.8.5 (b2016120813)