CA Adapter Windows 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.

AR_8.0--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 on the JBOSS installation directory:

   <JBOSS_HOME>\standalone\deployments\
   

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

   1. Create a directory in your file system.

      Example: C:\testDriver

   2. Place the Non-JDBC 4 compliant driver in this directory C:\testDriver, and name the Driver Jar.

      Example: YourJdbcDriver.jar

   3. Create META-INF\services directory in the location: C:\testDriver
   4. Create a file of java.sql.driver in C:\testDriver\META-INF\services directory, and 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 mentioned contents in it. Run the following command:

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

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