JDBC Connection to Oracle DB

[Luiz Lucena]

Hi friends, 

We are trying to connect to Oracle DB to get table information to populate our CMDB with the applications and responsibilities. 

In our DEV instance worked fine.

We moved to TEST instance and getting the error below, our DBA's are telling that this might be on ServiceNow side, but not sure yet.

The Query field is selected to bring all rows in the table.

_____

MID Server reported error: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
at com.service_now.monitor.jdbc.JDBCRowSet.query(JDBCRowSet.java:64)
at com.service_now.mid.probe.JDBCProbe.doSelect(JDBCProbe.java:312)
at com.service_now.mid.probe.JDBCProbe.doQuery(JDBCProbe.java:198)
at com.service_now.mid.probe.JDBCProbe.probe(JDBCProbe.java:123)
at com.service_now.mid.probe.AProbe.process(AProbe.java:84)
at com.service_now.mid.queue_worker.AWorker.runWorker(AWorker.java:125)
at com.service_now.mid.queue_worker.AWorkerThread.run(AWorkerThread.java:20)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)

_______

Any information would be much appreciated.

[Joel Millwood2]

Hi luizlucena,

Are you able to also include the query you are using in your Data Source please? Are you able to connect at all from your test instance?

[Luiz Lucena]

Hi Joel, 

Thanks for the quick response.

The query is out of the box, below, not sure where to find it to see the code.

[Joel Millwood2]

Thanks luizlucena, so this data source is configured exactly the same way in your DEV environment? How about mid servers, does your test environment use the same MID Server or a different one to your DEV environment?

[Luiz Lucena]

Connections are different and testing the connection it resolves with success.

I'm really thinking this is more at the Oracle side.