Which Oracle ojdbc driver should I use with Applications Manager?

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Applications Manager requires a copy of the Oracle ojdbc driver to be present in the $AW_HOME/web/classes directory to make a jdbc connection to the Oracle database.

Between ojdbc6.jar, ojdbc7.jar, and ojdbc8.jar, which Oracle ojdbc driver should I use with Applications Manager?

Environment

Release : 9.3.x

Component : Applications Manager

Resolution

The recommended ojdbc driver is dependent on the Oracle and Java versions.

The ojdbc6.jar and ojdbc7.jar is the recommended driver version when using Oracle 11g or below with JDK 6 or JDK 7.

The ojdbc8.jar is the recommended driver version when using Oracle 12c or 19c with JDK 8 or JDK 11.

Please refer to Oracle for more in depth information.