Copying the JDBC driver

This topic describes how to copy a JDBC driver for the Oracle sensor.

Important: Copy the driver that is compatible with the latest version of the Oracle that you discover, for example ojdbc7.jar. Optionally, you can copy more versions of the driver.
To copy the JDBC driver, complete the following steps:
  1. Get the JDBC driver file, for example classes12.jar, or ojdbc7.jar file from the Oracle website or from the Oracle installation media.
  2. Copy the file to the following location:
    $COLLATION_HOME/osgi/plugins/com.ibm.cdb.discover.sensor.app.db.oracle.oraclecommon_1.0.1/lib/oracle
  3. Add the name of the JDBC driver file to the Bundle-ClassPath entry in the MANIFEST.MF file of the OracleCommon sensor.
    1. Go to the $COLLATION_HOME/osgi/plugins/com.ibm.cdb.discover.sensor.app.db.oracle.oraclecommon_1.0.1/META-INF directory and open the MANIFEST.MF file in a text editor.
    2. Check whether the Bundle-ClassPath entry contains the name of the JDBC driver that you want to copy. The following example shows the correct entry for the ojdbc7.jar file:
      Bundle-ClassPath: lib/oracle/ojdbc7.jar,
 lib/oracle/ojdbc6.jar,
 lib/oracle/ojdbc5.jar,
 lib/oracle/classes12.jar
    3. If the entry does not contain the name of the driver that you want to copy, add the name manually as the first entry.
  4. Restart the Agile Service Manager server.