# JDBC Drivers Jar File(s) column missing in newer Ignition versions

**URL:** <https://forum.inductiveautomation.com/t/jdbc-drivers-jar-file-s-column-missing-in-newer-ignition-versions/64820>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [October 4, 2022, 8:27pm UTC](https://forum.inductiveautomation.com/t/jdbc-drivers-jar-file-s-column-missing-in-newer-ignition-versions/64820 "2022-10-04T20:27:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [October 4, 2022, 8:27pm UTC](https://forum.inductiveautomation.com/t/jdbc-drivers-jar-file-s-column-missing-in-newer-ignition-versions/64820/1 "2022-10-04T20:27:51Z")

</div>

On older versions of Ignition on the `Config > Database > Drivers & Settings` there used to be a column called `JAR File(s)` which seems to be missing on newer installs of Ignition.

7.9

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

8.1

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/8/489aa0f29db0f792999680ce4c5cb6ee049a80cb.png)

Was this info relocated somewhere else in the gateway config? It was very helpful ☹

Thanks!

---

<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:** [October 4, 2022, 8:44pm UTC](https://forum.inductiveautomation.com/t/jdbc-drivers-jar-file-s-column-missing-in-newer-ignition-versions/64820/2 "2022-10-04T20:44:16Z")

</div>

The column was removed because it was essentially a lie; it wasn't guaranteed to be accurate to any actual filename on disk. The names of the files on disk are immaterial, in any case; for JDBC drivers we just load up every .jar file in a folder into a special database classloader, then ask that classloader for the provided class name for your driver.

---

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [October 4, 2022, 8:57pm UTC](https://forum.inductiveautomation.com/t/jdbc-drivers-jar-file-s-column-missing-in-newer-ignition-versions/64820/3 "2022-10-04T20:57:00Z")

</div>

> [@paul-griffith](#):
>
> The names of the files on disk are immaterial, in any case; for JDBC drivers we just load up every .jar file in a folder into a special database classloader, then ask that classloader for the provided class name for your driver.

Interesting. So does this mean we can drop a newer version of a `.jar` in this folder\* `C:\Program Files\Inductive Automation\Ignition\user-lib\jdbc` and then restart the gateway without having to go in and edit the `.jar` file from the gateway config page?

\*Note: I assume we'd have to remove / backup the old one from this folder first... not sure how it would handle multiple versions of the same Classname

---

<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:** [October 4, 2022, 9:09pm UTC](https://forum.inductiveautomation.com/t/jdbc-drivers-jar-file-s-column-missing-in-newer-ignition-versions/64820/4 "2022-10-04T21:09:42Z")

</div>

Exactly that, yes.  
And, indeed - be sure you don't have multiple jar files providing the same class. Basically what will happen is that one is picked effectively at random, which becomes an absolute nightmare to debug.

---

<div class="post-metadata">

**Author:** ![kcollins](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kcollins/32/19646_2.png) [@kcollins](https://forum.inductiveautomation.com/u/kcollins)\
**Post date:** [October 4, 2022, 9:16pm UTC](https://forum.inductiveautomation.com/t/jdbc-drivers-jar-file-s-column-missing-in-newer-ignition-versions/64820/5 "2022-10-04T21:16:14Z")

</div>

One final supplementary statement here regarding the filename (which is still tracked in the internal config DB, just not displayed on the drivers page anymore)--its only use was to make an attempt to delete that .jar file when replacing a given JDBC driver entry through the web UI (with the goal of avoiding the situation Paul just described).

---

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [October 4, 2022, 9:17pm UTC](https://forum.inductiveautomation.com/t/jdbc-drivers-jar-file-s-column-missing-in-newer-ignition-versions/64820/6 "2022-10-04T21:17:22Z")

</div>

Awesome! Thanks for the info Paul & Kevin, I appreciate it
