Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | Adapter for JDBC Connections | Installing a JDBC Driver on Integration Server | Installing Multiple Versions of JDBC Driver on Integration Server
 
Installing Multiple Versions of JDBC Driver on Integration Server
*To install multiple versions of JDBC driver on Integration Server:
1. If you want to use multiple versions of JDBC drivers, then perform the following steps for each version:
a. 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).
b. 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
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:
a. ojdbc6.jar JAR file in Integration Server_directory/instances/instance_name/packages/WmJDBCAdapter/code/jars/oracleV6 folder.
b. 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.