# JDataConnect jar\_04

**URL:** <https://forum.inductiveautomation.com/t/jdataconnect-jar-04/7736>\
**Category:** Ignition\
**Created:** [December 19, 2013, 7:20pm UTC](https://forum.inductiveautomation.com/t/jdataconnect-jar-04/7736 "2013-12-19T19:20:54Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![markdobtech](https://avatars.discourse-cdn.com/v4/letter/m/71e660/32.png) [@markdobtech](https://forum.inductiveautomation.com/u/markdobtech)\
**Post date:** [December 19, 2013, 7:20pm UTC](https://forum.inductiveautomation.com/t/jdataconnect-jar-04/7736/1 "2013-12-19T19:20:54Z")

</div>

The classname for the JDataConnect JData4\_0.jar driver is ‘JData4\_0.sql.$Driver’. When attempting to save the entered classname in Database Drivers & Settings, a message appears that ‘$’ is an illegal character and will not allow save. Any ideas?

---

<div class="post-metadata">

**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:** [December 19, 2013, 7:24pm UTC](https://forum.inductiveautomation.com/t/jdataconnect-jar-04/7736/2 "2013-12-19T19:24:47Z")

</div>

Most unfortunate… I think we’ll have to fix that on our side.

---

<div class="post-metadata">

**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:** [December 19, 2013, 7:28pm UTC](https://forum.inductiveautomation.com/t/jdataconnect-jar-04/7736/3 "2013-12-19T19:28:06Z")

</div>

A wild workaround appears...

> [@](#):
>
> huh. Well, he could save it without the $ and edit it in the internal db...  
> which _might_ work... after a restart

---

<div class="post-metadata">

**Author:** ![markdobtech](https://avatars.discourse-cdn.com/v4/letter/m/71e660/32.png) [@markdobtech](https://forum.inductiveautomation.com/u/markdobtech)\
**Post date:** [December 19, 2013, 7:42pm UTC](https://forum.inductiveautomation.com/t/jdataconnect-jar-04/7736/4 "2013-12-19T19:42:42Z")

</div>

I was thinking along the lines of the internal db edit… What could possibly go wrong other than it might work?

---

<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:** [December 19, 2013, 10:15pm UTC](https://forum.inductiveautomation.com/t/jdataconnect-jar-04/7736/5 "2013-12-19T22:15:12Z")

</div>

Yeah, it’s not that big of a deal, you can try editing the row in the internal db. It will certainly let you set the value. The only problem would really be if you tried to edit some other aspect of the jdbc driver from the UI, it might not let you save again.

Also, after editing the internal db directly, you’ll likely need to restart the gateway. I’m not 100% sure about this, but since the edit events aren’t fired when the db is changed directly, the instances of the connection might not use the correct edit of the driver.

So, if you go to Console\>Advanced, you can look at the table with:

```auto
SELECT * FROM JDBCDRIVERS
```

Then just run an update statement on the classname column.

Regards,

---

<div class="post-metadata">

**Author:** ![markdobtech](https://avatars.discourse-cdn.com/v4/letter/m/71e660/32.png) [@markdobtech](https://forum.inductiveautomation.com/u/markdobtech)\
**Post date:** [December 23, 2013, 3:42pm UTC](https://forum.inductiveautomation.com/t/jdataconnect-jar-04/7736/6 "2013-12-23T15:42:06Z")

</div>

Direct update seemed to work. Driver returns a valid connection, but now there is a jdbc driver syntax issue. See post on same.

---

<div class="post-metadata">

**Author:** ![penrosekevin](https://avatars.discourse-cdn.com/v4/letter/p/f6c823/32.png) [@penrosekevin](https://forum.inductiveautomation.com/u/penrosekevin)\
**Post date:** [March 12, 2019, 1:12pm UTC](https://forum.inductiveautomation.com/t/jdataconnect-jar-04/7736/7 "2019-03-12T13:12:02Z")

</div>

I need to make this same change, but I’m not sure where I go to find the Console-\>Advanced editor. Can someone provide this?
