CA Strong Authentication Windows Installation Guide › Deploy CA Strong Authentication on a Single System › Post-Installation Tasks › How to Prepare the Application Server › Step 3: Copy JDBC JARs to the Application Server

Step 3: Copy JDBC JARs to the Application Server

The CA Advanced Authentication, UDS, and Sample Application, are the Java-dependent components that use JDBC JAR files to connect to the database. You copy these files to the application server.

Note: Before proceeding with the steps mentioned in the following sections, verify that you have downloaded the JDBC JAR file. See chapter, "Preparing for Installation" for more information about the supported JDBC JAR files.

Copy JDBC JARs to Apache Tomcat

Follow these steps:

1. Navigate to the location where you have downloaded the JDBC JAR file.
2. Copy the JDBC JAR file and paste it in the following directory:
   • For Apace Tomcat 5.5.x: <TOMCAT-HOME>\common\lib
   • For Apace Tomcat 6.x and 7.x: <TOMCAT-HOME>\lib

   Alternatively, add the path that contains the JDBC JAR file to the Classpath environment variable.

3. Restart Apache Tomcat.

Copy JDBC JARs to IBM WebSphere

Follow these steps:

1. Log in to IBM WebSphere Administration Console.
2. Click Environment, and then click Shared Libraries.
   1. From the Scope drop-down, select a valid visibility scope. The scope must include the target server/node on which the application is deployed.
   2. Click New.
   3. Enter the Name, for example, JDBCJAR.
   4. Specify the Classpath. This path must point to the location where the JDBC JAR file is present and must also include the file name.
   5. Click Apply.
3. Configure server-level class loaders.

   Note: You can create a class loader or use the one that you created while performing the procedure described in Step 2: Copying Database Access Files to Your Application Server.

   1. Navigate to Servers, Server Types, WebSphere Application Servers.
   2. Under Application Servers, access the settings page of the server for which the configuration is performed.
   3. Click Java and Process Management, and then click Class Loader.
   4. Click New. Select default Classes loaded with parent class loader first and click OK.
   5. Click the auto-generated Class Loader ID.
   6. In the class loader Configuration page, click Shared Library References.
   7. Click Add, select JDBCJAR and then click Apply.
   8. Save the changes.
4. Restart IBM WebSphere.

Copy JDBC JARs to Oracle WebLogic

Follow these steps:

Note: If you are using Oracle Database, then you need not perform the procedure that is described in this section because Oracle WebLogic Server supports Oracle Database by default.

1. Copy the JDBC JAR file to the following directory:

   <JAVA_HOME used by Oracle WebLogic instance>/jre/lib/ext

2. Log in to WebLogic Administration Console.
3. Navigate to Deployments.
4. Enable the Lock and Edit option.
5. Click Install and navigate to the directory that contains the JDBC JAR file.
6. Click Next.

   The Application Installation Assistant screen appears.

7. Click Next.

   The Summary page appears.

8. Click Finish.
9. Activate the changes.
10. Restart the Oracle WebLogic server.

Copy JDBC JARs to JBoss

Follow these steps:

1. Download the required JAR from any source, and then navigate to the location where you have downloaded it..
2. Create a folder structure as <JBOSS_HOME>\modules\advauth-jdbc-driver\main\ and copy JDBC Jar file in this folder location.
3. Create a file as ‘module.xml’ in the same location (<JBOSS_HOME>\modules\advauth-jdbc-driver\main\) with the following codes:

   <?xml version="1.0" encoding="UTF-8"?>
   <module xmlns="urn:jboss:module:1.1" name="advauth-jdbc-driver">
   <resources>
   <resource-root path="<JDBC Jar Name>"/>
   </resources>
       <dependencies>
           <module name="javax.api"/>
   <module name="javax.transaction.api"/>
       </dependencies>
   </module>
   

   Note: Edit the tag ‘<JDBC Jar Name>’with JDBC Jar file name.

   Example: sqljdbc.jar

4. Restart the application server.