# Connecting to mySQL 4.0.26 Cannot create PoolableConnectionFactory (ResultSet is from UPDATE. No Data.) **URL:** \ **Category:** Ignition\ **Created:** [October 16, 2019, 4:28pm UTC](https://forum.inductiveautomation.com/t/connecting-to-mysql-4-0-26-cannot-create-poolableconnectionfactory-resultset-is-from-update-no-data/29132 "2019-10-16T16:28:41Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Craighunter1986](https://avatars.discourse-cdn.com/v4/letter/c/bbe5ce/32.png) [@Craighunter1986](https://forum.inductiveautomation.com/u/Craighunter1986)\ **Post date:** [October 16, 2019, 4:28pm UTC](https://forum.inductiveautomation.com/t/connecting-to-mysql-4-0-26-cannot-create-poolableconnectionfactory-resultset-is-from-update-no-data/29132/1 "2019-10-16T16:28:41Z")
I am struggling to get a valid connection to a MySQL database. The SQL database is hosted on a machine which is remote from the Ignition server. I have set up a user in PHPMyAdmin with any host and global privileges. I have also turned the firewall off to see if that was blocking me. I read that MySQL 4.x is not fully supported but I should be able to connect. Does anyone have any advice? Cannot create PoolableConnectionFactory (ResultSet is from UPDATE. No Data.) java.sql.SQLException: Cannot create PoolableConnectionFactory (ResultSet is from UPDATE. No Data.) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2385) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:2110) at org.apache.commons.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:1563) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:257) at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:211) at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1016) at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:565) 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: ResultSet is from UPDATE. No Data. 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.ResultSetImpl.next(ResultSetImpl.java:6999) at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:4141) at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3548) 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 jdk.internal.reflect.GeneratedConstructorAccessor82.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:53) at org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:291) at org.apache.commons.dbcp2.BasicDataSource.validateConnectionFactory(BasicDataSource.java:2395) at org.apache.commons.dbcp2.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:2381) … 12 m ---
**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:** [October 16, 2019, 4:40pm UTC](https://forum.inductiveautomation.com/t/connecting-to-mysql-4-0-26-cannot-create-poolableconnectionfactory-resultset-is-from-update-no-data/29132/2 "2019-10-16T16:40:18Z")
What version of Ignition are you using and what version of the MySQL JDBC driver is installed? ---
**Author:** ![Craighunter1986](https://avatars.discourse-cdn.com/v4/letter/c/bbe5ce/32.png) [@Craighunter1986](https://forum.inductiveautomation.com/u/Craighunter1986)\ **Post date:** [October 16, 2019, 4:44pm UTC](https://forum.inductiveautomation.com/t/connecting-to-mysql-4-0-26-cannot-create-poolableconnectionfactory-resultset-is-from-update-no-data/29132/3 "2019-10-16T16:44:12Z")
V 8.0.2. I have looked at the MySQL drivers in Database\>Drivers but i can’t see what version I am using ---
**Author:** ![Craighunter1986](https://avatars.discourse-cdn.com/v4/letter/c/bbe5ce/32.png) [@Craighunter1986](https://forum.inductiveautomation.com/u/Craighunter1986)\ **Post date:** [October 21, 2019, 9:05am UTC](https://forum.inductiveautomation.com/t/connecting-to-mysql-4-0-26-cannot-create-poolableconnectionfactory-resultset-is-from-update-no-data/29132/4 "2019-10-21T09:05:15Z")
any ideas? ---
**Author:** ![Craighunter1986](https://avatars.discourse-cdn.com/v4/letter/c/bbe5ce/32.png) [@Craighunter1986](https://forum.inductiveautomation.com/u/Craighunter1986)\ **Post date:** [October 21, 2019, 10:00am UTC](https://forum.inductiveautomation.com/t/connecting-to-mysql-4-0-26-cannot-create-poolableconnectionfactory-resultset-is-from-update-no-data/29132/5 "2019-10-21T10:00:19Z")
Sorted! i tried an old MySQL connector 5.1.48 and managed to get it to work.