# Remote Database Connection **URL:** \ **Category:** Ignition\ **Created:** [July 17, 2025, 6:57pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639 "2025-07-17T18:57:16Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Post date:** [July 17, 2025, 6:57pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/1 "2025-07-17T18:57:16Z")
Hello I am trying to connect to a remote database on a remote PC. I have full connection between PCs. I can ping, remote in to each other, etc. However, when I make a database connection to it I can't get it to be valid. Connect URL: jdbc:mysqldb://172.30.110.31:3306/bbs\_db ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/2/f241efe55f7e5c7a4acad36646ab5ddc0083feb7.png) Error: ```python java.sql.SQLException: Cannot create JDBC driver of class 'com.mysql.cj.jdbc.Driver' for connect URL 'jdbc:mysqldb://172.30.110.31:3306/bbs_db' at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:75) at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:462) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:528) 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.SQLException: No suitable driver at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:68) ... 13 more 8.1.44 (b2024102210) Azul Systems, Inc. 17.0.12 ``` I have incoming / outgoing rules for port 3306, the correct password in the connection, etc. I have also tried turning off all firewalls and still the connection is faulted. Any thoughts on what I could be doing wrong? TIA. ---
**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:** [July 17, 2025, 6:58pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/2 "2025-07-17T18:58:43Z")
Can you post the full stack trace that goes along with the error? It might be in the logs if not in the status page you're looking at. ---
**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Post date:** [July 17, 2025, 6:59pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/3 "2025-07-17T18:59:49Z")
```python java.sql.SQLException: Cannot create JDBC driver of class 'com.mysql.cj.jdbc.Driver' for connect URL 'jdbc:mysqldb://172.30.110.31:3306/bbs_db' at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:75) at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:462) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:528) 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.SQLException: No suitable driver at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:68) ... 13 more 8.1.44 (b2024102210) Azul Systems, Inc. 17.0.12 ``` ---
**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:** [July 17, 2025, 7:03pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/4 "2025-07-17T19:03:46Z")
You sure you have the JDBC driver for MySQL installed? Look at [http://localhost:8088/web/config/database.drivers](http://localhost:8088/web/config/database.drivers) or equivalent. ---
**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Post date:** [July 17, 2025, 7:08pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/5 "2025-07-17T19:08:48Z")
I have never had to install any other version than the defaults that come with the basic vision install package. Good call though, it says I have an error on the remote PC driver? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/e/ce9356eed06d48ebe5ddda0003c14fc733a50d41.png) Not sure how to fix this. Any tips or any other information I could grab that would be helpful? ---
**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:** [July 17, 2025, 7:09pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/6 "2025-07-17T19:09:11Z")
![Screenshot 2025-07-17 at 12.08.57](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/0/50f5623afc4a17699d4a69b7cd389d1cf8c61a73.png) Follow that link to the user manual > **[JDBC Drivers and Translators | Ignition User Manual](https://docs.inductiveautomation.com/docs/8.1/platform/database-connections/connecting-to-databases/jdbc-drivers-and-translators)** > > There are cases where drivers or translators may need modification. ---
**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Post date:** [July 17, 2025, 7:10pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/7 "2025-07-17T19:10:27Z")
I will follow that trail, Thanks Kevin ---
**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:** [July 17, 2025, 7:12pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/8 "2025-07-17T19:12:18Z")
What's happening here is that you might be on a fresh install for the first time and being confronted with the fact that we stopped bundling the MySQL JDBC driver at some point, because their license doesn't allow for third parties to do so. If you've been working on upgraded or older Ignition installs you maybe never had to deal with it. It just needs to be installed manually. I think we've figured out a way to make this better in 8.3 by modularizing JDBC drivers and maybe including them in the installer or something. edit: or maybe modularization is just a step towards the installer being able to download and include them... not sure if we have that yet. ---
**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Post date:** [July 17, 2025, 7:13pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/9 "2025-07-17T19:13:40Z")
> [@Kevin.Herron](#): > > hink we've figured out a way to make this better in 8.3 by Weird though this is a fresh install but for 8.1.44 ---
**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:** [July 17, 2025, 7:14pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/10 "2025-07-17T19:14:16Z")
Unbundling MySQL probably happened years ago, so not surprising. ---
**Author:** ![Nol](https://avatars.discourse-cdn.com/v4/letter/n/8e8cbc/32.png) [@Nol](https://forum.inductiveautomation.com/u/Nol)\ **Post date:** [July 17, 2025, 7:14pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/11 "2025-07-17T19:14:23Z")
> [@William\_R](#): > > jdbc:mysqldb://172.30.110.31:3306/bbs\_db Have you tried: jdbc:mysqldb://172.30.110.31\MSSQLSERVER:3306 And then in Extra properties databaseName=bbs\_db ---
**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Post date:** [July 17, 2025, 7:20pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/12 "2025-07-17T19:20:32Z")
Still have the error unfortunately.. ```python java.sql.SQLException: Cannot create JDBC driver of class 'com.mysql.cj.jdbc.Driver' for connect URL 'jdbc:mysqldb://172.30.110.31:3306/bbs_db' at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:75) at org.apache.commons.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:462) at org.apache.commons.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:528) 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.SQLException: No suitable driver at org.apache.commons.dbcp2.DriverFactory.createDriver(DriverFactory.java:68) ... 13 more 8.1.44 (b2024102210) Azul Systems, Inc. 17.0.12 ``` ---
**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:** [July 17, 2025, 7:22pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/13 "2025-07-17T19:22:29Z")
Does that page say you have a valid MySQL JDBC driver now? Have you restarted the Ignition Gateway since placing those JAR files? ---
**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Post date:** [July 17, 2025, 7:26pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/14 "2025-07-17T19:26:14Z")
Thanks but that didn't work 😕 ---
**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Post date:** [July 17, 2025, 7:27pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/15 "2025-07-17T19:27:49Z")
After I installed the JAR file the error for the driver went away. I also restarted the gateway. ---
**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:** [July 17, 2025, 7:29pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/16 "2025-07-17T19:29:56Z")
Might need to get with support so they can take a look. There must be something with the the JDBC driver install, because the error indicates it can't be found. ---
**Author:** ![William\_R](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/william_r/32/32710_2.png) [@William\_R](https://forum.inductiveautomation.com/u/William_R)\ **Post date:** [July 17, 2025, 7:30pm UTC](https://forum.inductiveautomation.com/t/remote-database-connection/108639/17 "2025-07-17T19:30:11Z")
Will do thanks man