# MariaDB NewConnection

**URL:** <https://forum.inductiveautomation.com/t/mariadb-newconnection/96446>\
**Category:** Ignition\
**Tags:** database\
**Created:** [September 25, 2024, 5:33pm UTC](https://forum.inductiveautomation.com/t/mariadb-newconnection/96446 "2024-09-25T17:33:13Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ha99](https://avatars.discourse-cdn.com/v4/letter/h/7feea3/32.png) [@Ha99](https://forum.inductiveautomation.com/u/Ha99)\
**Post date:** [September 25, 2024, 5:33pm UTC](https://forum.inductiveautomation.com/t/mariadb-newconnection/96446/1 "2024-09-25T17:33:13Z")

</div>

Hi,  
I just installed the latest version of MariaDB 11.4.3 and I followed the procedure to update the jdbc driver [JDBC Drivers and Translators | Ignition User Manual](https://www.docs.inductiveautomation.com/docs/8.1/platform/database-connections/connecting-to-databases/jdbc-drivers-and-translators), except that I got an error, my connection is faulted:

> java.sql.SQLException: Cannot create PoolableConnectionFactory (Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=161) Unknown database 'test')  
> 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:300)  
> at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.runTest(DatasourceImpl.java:253)  
> at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$FaultedDatasourceRetryer.lambda$newRetryRunnable$0(DatasourceManagerImpl.java:1097)  
> at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$TrackedTask.run(BasicExecutionEngine.java:593)  
> 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.SQLSyntaxErrorException: Could not connect to address=(host=localhost)(port=3306)(type=master) : (conn=161) Unknown database 'test'  
> at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)  
> at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:194)  
> at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1394)  
> at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:635)  
> at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:150)  
> at org.mariadb.jdbc.Driver.connect(Driver.java:89)  
> 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.sql.SQLSyntaxErrorException: (conn=161) Unknown database 'test'  
> at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:62)  
> at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:189)  
> at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.authenticationHandler(AbstractConnectProtocol.java:778)  
> at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.createConnection(AbstractConnectProtocol.java:555)  
> at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1389)  
> ... 19 more
> 
> 8.1.43 (b2024082010)  
> Azul Systems, Inc. 17.0.11

---

<div class="post-metadata">

**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:** [September 25, 2024, 5:36pm UTC](https://forum.inductiveautomation.com/t/mariadb-newconnection/96446/2 "2024-09-25T17:36:50Z")

</div>

> [@Ha99](#):
>
> Caused by: java.sql.SQLSyntaxErrorException: (conn=161) Unknown database 'test'

do you have a database named 'test'?

---

<div class="post-metadata">

**Author:** ![Ha99](https://avatars.discourse-cdn.com/v4/letter/h/7feea3/32.png) [@Ha99](https://forum.inductiveautomation.com/u/Ha99)\
**Post date:** [September 25, 2024, 5:40pm UTC](https://forum.inductiveautomation.com/t/mariadb-newconnection/96446/3 "2024-09-25T17:40:26Z")

</div>

yes

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/d/5d226bde014015d16ec536b792dcb97b41c0dca9.png)

---

<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:** [September 25, 2024, 5:41pm UTC](https://forum.inductiveautomation.com/t/mariadb-newconnection/96446/4 "2024-09-25T17:41:13Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/3/3389e2534bffb47900908f87ca2b9ebcd82d58b0.png)  
No you don't, you have a database _connection_ in your GUI tool named "test", but nothing **in your actual MariaDB instance** named "test".

Other RDBMSes call this a "schema", if that's something you're more familiar with.