# AdHoc JDBC Queries without Ignition DataSources

**URL:** <https://forum.inductiveautomation.com/t/adhoc-jdbc-queries-without-ignition-datasources/61134>\
**Category:** Ignition\
**Tags:** database, scripting\
**Created:** [June 23, 2022, 8:42pm UTC](https://forum.inductiveautomation.com/t/adhoc-jdbc-queries-without-ignition-datasources/61134 "2022-06-23T20:42:19Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rory\_Gilliland](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@Rory\_Gilliland](https://forum.inductiveautomation.com/u/Rory_Gilliland)\
**Post date:** [June 23, 2022, 8:42pm UTC](https://forum.inductiveautomation.com/t/adhoc-jdbc-queries-without-ignition-datasources/61134/1 "2022-06-23T20:42:19Z")

</div>

I have a dynamic set of database server connections (100+). Is it possible to create a jdbc connection via scripting using something similar to the jython zxJDBC package to handle connections temporarily, rather than creating gateway data sources?  
Would it better to dynamically create and remove / disable dataSources using the system.db.addDatasource() to avoid keeping a large list of connections running on the gateway?

---

<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:** [June 23, 2022, 9:42pm UTC](https://forum.inductiveautomation.com/t/adhoc-jdbc-queries-without-ignition-datasources/61134/2 "2022-06-23T21:42:39Z")

</div>

It is _possible_, yes. I would avoid any Jython libraries and directly use JDBC methods. You’re going to want to do it from the gateway, and I would _recommend_ using a module to introduce the necessary JDBC driver classes into your scripting scope (Ignition’s JDBC drivers are on an isolated classloader, so you aren’t able to directly make connections using them).

---

<div class="post-metadata">

**Author:** ![Rory\_Gilliland](https://avatars.discourse-cdn.com/v4/letter/r/90ced4/32.png) [@Rory\_Gilliland](https://forum.inductiveautomation.com/u/Rory_Gilliland)\
**Post date:** [June 24, 2022, 2:47pm UTC](https://forum.inductiveautomation.com/t/adhoc-jdbc-queries-without-ignition-datasources/61134/3 "2022-06-24T14:47:00Z")

</div>

Okay thank you. The isolated classloader explains why I was not able to access the existing JDBC driver.