Oracle JDBC - goes NW 7.11 with ojdbc5.jar?

[former_member508372]

We have an rather old PI 7.11 with oracle 12.1.0.2.0 database, which uses ojdbc14.jar from oracle client 11.2.0.4 V3 as system rdbms driver.

Now we have a PI scenario with a newer external 12c database, which we want to connect with PIs jdbc adapter. The new database requires at minimum ojdbc5.jar

It seem's that we can't deploy a different oracle driver to use with PI jdbc adapter, because PI jdbc adapter points to rquired driver only by java class name. Thus alway system jdbc driver is used when classname is "oracle.jdbc.OracleDriver"

Now we wonder, if PI 7.11 (Java 5) goes with ojdbc5.jar as system driver? There is an ojdbc5.jar file in oracle instantclient directory.

But SAP says in Oracle jdbc FAQ

https://launchpad.support.sap.com/#/notes/867176

that ojdbc14.jar is the right driver for SAP 7.1x Releases with Java 5. But FAQ was last updatet 2016. There is newer oracle client 11.2.04. V4 (Jan. 2018) from SAP available.

Does anyone know if we can run NW 7.11 with ojdbc5.jar?

[Faison]

Hello Roland,

You could refer to KBA 1615198. The Java version for NW PI 7.11 is 5 (JRE 5) which is compatible with ojdbc5.jar.

Therefore, you can run NW 7.11 with ojdbc5.jar.

Best Regards, Faison

[former_member508372]

The question is, if we can run PI7.11 with ojdbc5.jar as system driver? KBA 1615198 refers to driver for PI's jdbc adapter not to systems jdbc driver.

We deployed ojdbc5.jar as driver for jdbc adapter. But it didn't work. We assume that we can't deploy another ojdbc driver for jdbc adapter than the systems ojdbc driver.