# I got this error when clicking drivers under database in config

**URL:** <https://forum.inductiveautomation.com/t/i-got-this-error-when-clicking-drivers-under-database-in-config/61768>\
**Category:** Ignition\
**Tags:** database\
**Created:** [July 12, 2022, 1:27am UTC](https://forum.inductiveautomation.com/t/i-got-this-error-when-clicking-drivers-under-database-in-config/61768 "2022-07-12T01:27:49Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![prashants](https://avatars.discourse-cdn.com/v4/letter/p/a87d85/32.png) [@prashants](https://forum.inductiveautomation.com/u/prashants)\
**Post date:** [July 12, 2022, 1:27am UTC](https://forum.inductiveautomation.com/t/i-got-this-error-when-clicking-drivers-under-database-in-config/61768/1 "2022-07-12T01:27:49Z")

</div>

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/b/6bd60dead30f85e7611bb6b78e73f05bfd88ed91.png)  
I tried to update the MSSQL driver but think I used the wrong version. Does anyone know how to fix this error?  
Thanks.

---

<div class="post-metadata">

**Author:** ![zacht](https://avatars.discourse-cdn.com/v4/letter/z/ea5d25/32.png) [@zacht](https://forum.inductiveautomation.com/u/zacht)\
**Post date:** [July 12, 2022, 5:50pm UTC](https://forum.inductiveautomation.com/t/i-got-this-error-when-clicking-drivers-under-database-in-config/61768/2 "2022-07-12T17:50:57Z")

</div>

My best guess (someone more knowledgeable is welcome to correct me):

1. Take a gateway backup.
2. On the Ignition computer, backup the folder `%Ignition Install Folder%\user-lib\jdbc`.
3. Replace the JDBC jar with something your version of Java supports.
4. You may need to restart the gateway.

> **[Support matrix - JDBC Driver for SQL Server](https://docs.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver16)**
>
> This page contains the support matrix and support life-cycle policy for the Microsoft JDBC Driver for SQL Server.

---

<div class="post-metadata">

**Author:** ![prashants](https://avatars.discourse-cdn.com/v4/letter/p/a87d85/32.png) [@prashants](https://forum.inductiveautomation.com/u/prashants)\
**Post date:** [July 15, 2022, 1:46am UTC](https://forum.inductiveautomation.com/t/i-got-this-error-when-clicking-drivers-under-database-in-config/61768/3 "2022-07-15T01:46:00Z")

</div>

Thanks, I removed the jdbc folder and restarted ignition and I don’t have that error anymore.  
However, I followed the instructions on Inductive University Course to install the MySQL driver and created a connection but it still says faulted.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/3/236a308693863d7fa9ed5c17d448a42be3a5642b.png)

Here is the error I got. Please let me know if you have any idea what’s causing this error. Thanks.

````auto
java.lang.ClassNotFoundException: org.apache.commons.dbcp2.BasicDataSourceFactory
	at java.base/java.net.URLClassLoader.findClass(Unknown Source)
	at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
	at java.base/java.lang.ClassLoader.loadClass(Unknown Source)
	at com.inductiveautomation.ignition.gateway.IgnitionGateway.createDataSource(IgnitionGateway.java:2808)
	at com.inductiveautomation.ignition.gateway.datasource.DatasourceImpl.<init>(DatasourceImpl.java:224)
	at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl.installDatasource(DatasourceManagerImpl.java:496)
	at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$DatasourceRecordListener.recordUpdated(DatasourceManagerImpl.java:931)
	at com.inductiveautomation.ignition.gateway.datasource.DatasourceManagerImpl$DatasourceRecordListener.recordUpdated(DatasourceManagerImpl.java:884)
	at com.inductiveautomation.ignition.gateway.localdb.PersistenceInterfaceImpl.notifyRecordUpdated(PersistenceInterfaceImpl.java:179)
	at com.inductiveautomation.ignition.gateway.redundancy.RedundantPersistenceInterfaceImpl.doNotifyRecordUpdated(RedundantPersistenceInterfaceImpl.java:111)
	at com.inductiveautomation.ignition.gateway.redundancy.RedundantPersistenceInterfaceImpl$RecordUpdateListener.recordUpdated(RedundantPersistenceInterfaceImpl.java:407)
	at com.inductiveautomation.ignition.gateway.redundancy.RedundantPersistenceInterfaceImpl$RecordUpdateMessage.notify(RedundantPersistenceInterfaceImpl.java:457)
	at com.inductiveautomation.ignition.gateway.redundancy.RedundantPersistenceInterfaceImpl$RecordUpdateListener.receiveCall(RedundantPersistenceInterfaceImpl.java:390)
	at com.inductiveautomation.ignition.gateway.redundancy.QueueableMessageReceiver.receiveCall(QueueableMessageReceiver.java:47)
	at com.inductiveautomation.ignition.gateway.redundancy.RedundancyManagerImpl.dispatchMessage(RedundancyManagerImpl.java:966)
	at com.inductiveautomation.ignition.gateway.redundancy.RedundancyManagerImpl$ExecuteTask.run(RedundancyManagerImpl.java:1041)
	at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:539)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.base/java.util.concurrent.FutureTask.run(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)

8.1.13 (b2021122109)
Azul Systems, Inc. 11.0.13```
````

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [July 15, 2022, 10:04am UTC](https://forum.inductiveautomation.com/t/i-got-this-error-when-clicking-drivers-under-database-in-config/61768/4 "2022-07-15T10:04:24Z")

</div>

Did you pick a JDBC driver that is compatible with java 11 ? And did you deliberately switch from MS SQL Server to MySQL ?