I am getting error with the oracle JBDC connection through the mid server

[ginjupalli]

we are trying to do integration through the data sources to connect the oracle data base, when I defined the data source and test load 20 records , the following error is displaying

MID Server reported error: java.sql.SQLException: java.sql.SQLRecoverableException: IO Error: JNDI Package failure javax.naming.CommunicationException: localhost:389 [Root exception is java.net.ConnectException: Connection refused: connect]
oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
java.sql.DriverManager.getConnection(DriverManager.java:664)
java.sql.DriverManager.getConnection(DriverManager.java:208)
com.service_now.mid.connections.jdbc.JDBCConnection.establishConnection(JDBCConnection.java:102)
com.service_now.mid.connections.jdbc.JDBCConnection.connect(JDBCConnection.java:74)
com.service_now.mid.connections.jdbc.JDBCConnectionFactory.create(JDBCConnectionFactory.java:52)
com.service_now.mid.connections.ConnectionCachePool.getAvailableConnection(ConnectionCachePool.java:82)
com.service_now.mid.connections.ConnectionCache.get(ConnectionCache.java:94)
com.service_now.mid.probe.JDBCProbe.getJDBCConnection(JDBCProbe.java:768)
com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:116)
com.service_now.mid.probe.AProbe.process(AProbe.java:83)
com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:119)
com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20)
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
java.lang.Thread.run(Thread.java:745)

at com.service_now.mid.probe.JDBCProbe.getJDBCConnection(JDBCProbe.java:772)
at com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:116)
at com.service_now.mid.probe.AProbe.process(AProbe.java:83)
at com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:119)
at com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

can some one please, help me with the data source.

.

[Ankur Bawiskar]

Hi Ginjupalli,

Did you configure the username, password and other fields properly?

Also can you check by logging to the mid server whether you can connect to the jdbc server or not?

check this link: https://community.servicenow.com/community?id=community_question&sys_id=3a8447a9dbd8dbc01dcaf3231f9619b3

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[Ankur Bawiskar]

Hi Ginjupalli,

Any update on this?
Can you mark my answer as correct, helpful if you were able to achieve the requirement. This helps in removing this question from unanswered list and helps users to learn from your thread. Thanks in advance.

Regards
Ankur