# Oracle Table Connections

**URL:** <https://forum.inductiveautomation.com/t/oracle-table-connections/3479>\
**Category:** General Discussion\
**Created:** [October 24, 2011, 5:00pm UTC](https://forum.inductiveautomation.com/t/oracle-table-connections/3479 "2011-10-24T17:00:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jlr573](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jlr573](https://forum.inductiveautomation.com/u/jlr573)\
**Post date:** [October 24, 2011, 5:00pm UTC](https://forum.inductiveautomation.com/t/oracle-table-connections/3479/1 "2011-10-24T17:00:07Z")

</div>

I’m using Oracle Express 11g and when I go into Ignitions database query browser it show me all of these tables that came with Oracle, I don’t really want to remove these tables. I can go into Oracle SQL Developer and create a new connection, but how do I connect to it in the Gateway?  
Right now the connect URL is “jdbc:oracle:thin:@localhost:1521:XE” Oracle has a HR connection that comes with the database to demo a Human Resource application. I tried changing the "XE to “HR” and changing the user name and password but that faulted the DB connection with this error “Cannot create PoolableConnectionFactory (Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor )”

So my question is if I create a new connection in Oracle how do I connect to it through the gateway?

---

<div class="post-metadata">

**Author:** ![jlr573](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jlr573](https://forum.inductiveautomation.com/u/jlr573)\
**Post date:** [October 24, 2011, 5:05pm UTC](https://forum.inductiveautomation.com/t/oracle-table-connections/3479/2 "2011-10-24T17:05:27Z")

</div>

Actually just found the answer to this. All you have to do is change the connect URL from jdbc:oracle:thin:@localhost:1521:XE to jdbc:oracle:thin:hr@localhost:1521:XE  
If the connection you want to make is hr then include it in the connect URL just before the @localhost

---

<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:** [October 24, 2011, 8:24pm UTC](https://forum.inductiveautomation.com/t/oracle-table-connections/3479/3 "2011-10-24T20:24:16Z")

</div>

I’m glad you figured it out, and even more glad you posted it! I actually didn’t know about this, and I’m sure it will help others.

Thanks,