# JDBC driver w/ required DLL

**URL:** <https://forum.inductiveautomation.com/t/jdbc-driver-w-required-dll/6471>\
**Category:** Ignition\
**Created:** [May 14, 2013, 4:26pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-w-required-dll/6471 "2013-05-14T16:26:22Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [May 14, 2013, 4:26pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-w-required-dll/6471/1 "2013-05-14T16:26:22Z")

</div>

I have a JDBC driver(PI JDBC, trying to interface Ignition to our historian) that has a required DLL along with it. I was planning on installed it on the same system as my Ignition setup and bringing the .Jar into Ignition.

Before I do this -  
A. Will this work in general? (JDBC w/ dll)  
B. Any pitfalls I should be aware of?

---

<div class="post-metadata">

**Author:** ![pphillips](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@pphillips](https://forum.inductiveautomation.com/u/pphillips)\
**Post date:** [May 15, 2013, 7:16pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-w-required-dll/6471/2 "2013-05-15T19:16:42Z")

</div>

I don’t have any advice on this, but I’d be interested to know if you can get it to work. We also have a couple of PI servers that I would like to connect to at some point. Thanks.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [May 16, 2013, 4:23pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-w-required-dll/6471/3 "2013-05-16T16:23:28Z")

</div>

Hey,

I just happened to write up a document about this yesterday: [Using OSI PI JDBC with Ignition](http://files.inductiveautomation.com.s3.amazonaws.com/whitepapers/Using_OSI_PI_JDBC_with_Ignition.pdf)

So in my testing, I kept it simple and had Ignition on the same machine as PI, but honestly, I don’t think you really need to worry about the dll. I think the installer for the JDBC driver will make sure it’s somewhere accessible, like “system32”.

The only other thing about using PI, as mention in that document: values returned as variants will result in “Unknown Type 2000” errors. We’ve tweaked 7.5.9 (and 7.6.1) to avoid this error in many cases, but there are still some places that can’t deal with the variant. The work around is simply to cast your value columns in the query (e.g. “SELECT cast(value as Float32) …”)

Let me know how it goes,

---

<div class="post-metadata">

**Author:** ![Dravik](https://avatars.discourse-cdn.com/v4/letter/d/e274bd/32.png) [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\
**Post date:** [May 16, 2013, 6:00pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-w-required-dll/6471/4 "2013-05-16T18:00:09Z")

</div>

Are you a psychic Colby?  
Cause, That’s awesome.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [May 16, 2013, 6:49pm UTC](https://forum.inductiveautomation.com/t/jdbc-driver-w-required-dll/6471/5 "2013-05-16T18:49:46Z")

</div>

Haha, it doesn’t take a psychic when you get asked about something at least once a month for several years… just coincidental that I finally got around to working on it this week! 😆