CA Adapter UNIX Installation Guide › Deploying and Configuring State Manager › Copying the JDBC Drivers › Apache Tomcat

Apache Tomcat

Perform the following steps to copy the JDBC drivers:

1. Navigate to the following directory:

   For MS SQL Server:

   state_manager_installation_dir/adapterStateManager/mssql

   For MySQL:

   state_manager_installation_dir/adapterStateManager/mysql

   For Oracle:

   state_manager_installation_dir/adapterStateManager/oracle

2. Copy the JAR file corresponding to the database that you are using to the following application server installation directory.

   For Apache Tomcat 5.5.x:

   Tomcat_root/common/lib

   For Apache Tomcat 6.x and 7.x:

   Tomcat_root/lib

   Note: Tomcat_root refers to the Apache Tomcat installation directory.

3. Restart Apache Tomcat.

JBoss

Perform the following steps to copy JDBC JAR file to JBoss.

Follow these steps:

1. Copy the JDBC JAR file to the following location in the JBOSS installation directory:

   JBOSS_HOME/standalone/deployments

   Note: If your JDBC Driver is NOT JDBC 4-compliant then we can update the driver using “jar” utility by adding the META-INF/services/java.sql.Driver in it. Do the following steps:

   1. Create a directory in your file system. Example: /home/userone/testDriver
   2. Place your Non-JDBC 4 compliant driver in this directory: /home/userone/testDriver. Name the Driver Jar name as YourJdbcDriver.jar.
   3. Create META-INF/services directory in the location: /home/userone/testDriver
   4. Create a file with name java.sql.Driver in /home/userone/testDriver/META-INF/services directory. Add the fully qualified name of your JDBC Driver class in this file.
   5. Use the jar utility with -u (means update) option to add the META-INF directory with the earlier contents. Run the following command:

      jar  -uf  YourJdbcDriver.jar  META-INF/services/java.sql.Driver
      

   6. Place the JDBC Driver in the <JBOSS_HOME>/standalone/deployments.
2. Restart the application server.