# Try to add a jdbc driver for HQSLDB **URL:** \ **Category:** Ignition\ **Created:** [October 24, 2011, 1:29pm UTC](https://forum.inductiveautomation.com/t/try-to-add-a-jdbc-driver-for-hqsldb/3478 "2011-10-24T13:29:23Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![mazeyrat](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mazeyrat/32/10955_2.png) [@mazeyrat](https://forum.inductiveautomation.com/u/mazeyrat)\ **Post date:** [October 24, 2011, 1:29pm UTC](https://forum.inductiveautomation.com/t/try-to-add-a-jdbc-driver-for-hqsldb/3478/1 "2011-10-24T13:29:23Z")
I try to add a jdbc driver for HSQLDB. I’ve started a server with the following cmd : java -cp D:/Appli/itinisere/BDD/hsqldb-2.2.5/hsqldb/lib/hsqldb.jar org.hsqldb.server.Server --database.0 file:D:/Appli/itinisere/BDD/test/test --dbname.0 itinisere I success to connect with HSQLDB ManagerSwing or java application. The database connexion is faulted from ignition gateway ! Faulted rg.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (unexpected end of statement) org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225)org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:189)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:145)com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.run(DatasourceManagerImpl.java:1086)java.lang.Thread.run(Thread.java:662) java.sql.SQLSyntaxErrorException: unexpected end of statement org.hsqldb.jdbc.Util.sqlException(Util.java:350)org.hsqldb.jdbc.Util.sqlException(Util.java:227)org.hsqldb.jdbc.JDBCStatement.fetchResult(JDBCStatement.java:1830)org.hsqldb.jdbc.JDBCStatement.executeQuery(JDBCStatement.java:181)org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:332)org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1249)org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221)org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:189)com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:145)com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.run(DatasourceManagerImpl.java:1086)java.lang.Thread.run(Thread.java:662) ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/09a307f664016c80e82a3145bd2027bb64cca7b6.png) ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [October 25, 2011, 10:23pm UTC](https://forum.inductiveautomation.com/t/try-to-add-a-jdbc-driver-for-hqsldb/3478/2 "2011-10-25T22:23:36Z")
Your validation query, “Select 1”, is not a valid statement for HSQLDB, hence the “Unexpected end of statement” error. Try “select 1 from dual” ---
**Author:** ![deduar](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@deduar](https://forum.inductiveautomation.com/u/deduar)\ **Post date:** [August 20, 2013, 4:05am UTC](https://forum.inductiveautomation.com/t/try-to-add-a-jdbc-driver-for-hqsldb/3478/3 "2013-08-20T04:05:16Z")
Hi. I try to create new DataBase driver for HSQLDB but I get this error org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (unexpected end of statement) org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1225) org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:194) com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:150) com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.run(DatasourceManagerImpl.java:1103) java.lang.Thread.run(Thread.java:662) java.sql.SQLSyntaxErrorException: unexpected end of statement org.hsqldb.jdbc.Util.sqlException(Unknown Source) org.hsqldb.jdbc.Util.sqlException(Unknown Source) org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source) org.hsqldb.jdbc.JDBCStatement.executeQuery(Unknown Source) org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) org.apache.commons.dbcp.PoolableConnectionFactory.validateConnection(PoolableConnectionFactory.java:332) org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1249) org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1221) org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880) com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.getConnectionInternal(DatasourceImpl.java:194) com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:150) com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.run(DatasourceManagerImpl.java:1103) java.lang.Thread.run(Thread.java:662) Can help me Thanks - deduar ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [August 21, 2013, 6:25pm UTC](https://forum.inductiveautomation.com/t/try-to-add-a-jdbc-driver-for-hqsldb/3478/4 "2013-08-21T18:25:38Z")
Sounds like you have the exact same problem as the original poster on this thread. Did you try the solution I posted two years ago (above)? ---
**Author:** ![deduar](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@deduar](https://forum.inductiveautomation.com/u/deduar)\ **Post date:** [August 22, 2013, 5:32pm UTC](https://forum.inductiveautomation.com/t/try-to-add-a-jdbc-driver-for-hqsldb/3478/5 "2013-08-22T17:32:36Z")
off course I tried first the solution (above) before to post the message, but don’t work A one difference is that I running the HSQL on memory, the url that I using are : jdbc:hsqldb:hsql://localhost/dbName, is Not necessary the port ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [August 22, 2013, 6:30pm UTC](https://forum.inductiveautomation.com/t/try-to-add-a-jdbc-driver-for-hqsldb/3478/6 "2013-08-22T18:30:06Z")
Ok, so what validation query are you running? ---
**Author:** ![deduar](https://avatars.discourse-cdn.com/v4/letter/d/9f8e36/32.png) [@deduar](https://forum.inductiveautomation.com/u/deduar)\ **Post date:** [September 1, 2013, 3:39pm UTC](https://forum.inductiveautomation.com/t/try-to-add-a-jdbc-driver-for-hqsldb/3478/7 "2013-09-01T15:39:33Z")
Hi, I’m using “select 1 from dual” Thanks deduar ---
**Author:** ![dave.fogle](https://avatars.discourse-cdn.com/v4/letter/d/43a26b/32.png) [@dave.fogle](https://forum.inductiveautomation.com/u/dave.fogle)\ **Post date:** [January 9, 2014, 6:23pm UTC](https://forum.inductiveautomation.com/t/try-to-add-a-jdbc-driver-for-hqsldb/3478/8 "2014-01-09T18:23:43Z")
First I think you need to use HSQLDB's in memory connect url which is something like: jdbc:hsqldb:mem:aname From my research it seems like the mem keyword is necessary to specify that you are running in memory.