55 views

Description

Oracle JDBC Driver 11.2.0.3.0 included in MID Server lib folder is old, and incompatible with at least Oracle 8i. This is used by Import Set Data Sources and Orchestration/Integration Hub activities when an Oracle Database is targeted.

The MID Server installation contains agent/lib/ojdbc6.jar is currently "Oracle 11.2.0.3.0 JDBC 4.0 compiled with JDK6 on Fri_Aug_26_08:19:15_PDT_2011"
That has problems connecting to Oracle 8i, which the newer "Oracle 11.2.0.4.0 JDBC 4.0 compiled with JDK6 on Thu_Jul_03_18:17:32_PDT_2014" doesn't.
An Oracle 12.1.0.1.0 version also exists.

Steps to Reproduce

Confirm the version using this command from the mid server agent folder:
.\jre\bin\java.exe -jar .\lib\ojdbc6.jar
./jre/bin/java -jar ./lib/ojdbc6.jar

Workaround

This problem is currently under review. You can contact ServiceNow Technical Support or subscribe to this Known Error article by clicking the Subscribe button at the top right of this form to be notified when more information will become available.

The same workaround as PRB1433170 can be used, which involves adding the newer driver to the instance JAR Files, and then changing the class path order in wrapper-override.conf in the MID Server:
PRB1433170 / KB0862383 - The jar files for Oracle/MSSQL/MySQL JDBC drivers on MID Servers are in the lib folder, not the JAR Files table, and so can't be swapped out for different versions to be compatible with all versions of those databases


Related Problem: PRB1441208

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-10-23 01:06:00
Published:2020-10-23