Installing Multiple Versions of JDBC Driver on Integration Server

About this task

To install multiple versions of JDBC driver on Integration Server:

Procedure

If you want to use multiple versions of JDBC drivers, then perform the following steps for each version:
  1. Create a new folder with a meaningful name in Integration Server_directory/instances/instance_name/packages/WmJDBCAdapter/code/jars. For example, folder oracleV8 to contain Oracle Version 8 JAR file(s).
  2. Place the JDBC driver JAR file(s) in the folder.
    Note: Ensure that none of the related driver JAR file(s) of other versions are placed inside any of the classpaths of Integration Server:
    • Default driver group classpath: Integration Server_directory/instances/instance_name/packages/WmJDBCAdapter/code/jars
    • Static folder classpath: Integration Server_directory/instances/instance_name/packages/WmJDBCAdapter/code/jars/static
    • Integration Server common library classpath: Integration Server_directory/common/lib

Example

For example, if you want to use multiple Oracle specific JAR file(s) such as ojdbc8.jar and ojdbc6.jar, you must perform the following:
  1. Create two new folders oracleV8 and oracleV6 in Integration Server_directory/instances/instance_name/packages/WmJDBCAdapter/code/jars. Similarly, you can create folders for other databases with the following names:
    • mssqlV11
    • mssqlV10
    • mssqlV8
    • mysqlV8
    • mysqlV5.1.40
  2. Place the respective JDBC driver JAR file(s) in this folder. For example:
    1. ojdbc6.jar JAR file in Integration Server_directory/instances/instance_name/packages/WmJDBCAdapter/code/jars/oracleV6 folder.
    2. ojdbc8.jar JAR file in Integration Server_directory/instances/instance_name/packages/WmJDBCAdapter/code/jars/oracleV8 folder.

    You can see oracleV8 and oracleV6 in the Driver Group dropdown in the JDBC Connection page.

  3. In the JDBC Connection page, select the Driver Group based on your requirements.
    Note: Ensure that none of the related driver JAR file(s) of other versions are placed inside any of the classpaths of Integration Server: Default driver group classpath, Static folder classpath or Integration Server common library classpath.