CA Risk Authentication Windows Installation Guide › How to Deploy CA Risk Authentication on a Single System › How to Prepare an Application Server › Copy the JDBC JAR Files to Application Server

Copy the JDBC JAR Files to Application Server

CA Risk Authentication requires the following JDBC JAR files for the supported databases:

• Oracle 10g: Oracle JDBC Driver (10.2.0.1.0)
• Oracle 11g: Oracle JDBC Driver (11.2.0.2.0)
• Microsoft SQL Server: MSSQL JDBC Driver (1.2.2828)
• MySQL: MySQL JDBC Driver (5.1.22)

The following sections walk you through the steps for copying the JDBC JAR required for your database:

Apache Tomcat

Follow these steps:

1. Navigate to the location where you have downloaded the <Database_JAR> file.
2. Copy the <Database_JAR> file to the following directory:
   • On Apache Tomcat 5.5.x: <TOMCAT_HOME>\common\lib\
   • On Apache Tomcat 6.x and 7.x: <TOMCAT_HOME>\lib\
3. Restart the server.

IBM WebSphere

Follow these steps:

1. Log in to the WebSphere Administration Console.
2. Click Environment, and click Shared Libraries. Do the following steps:
   1. From the Scope list, select a valid visibility scope. Include the target server or node on which the application is deployed.
   2. Click New.
   3. Enter the Name.

      Example: JDBCJAR.

   4. Specify the Classpath.

      Important! This path must point to the location where the <Database_JAR> file is present and must include the file name.

   5. Click Apply.
3. Configure server-level class loaders, and do the following steps:
   1. Navigate to Servers, Server Types, WebSphere Application Servers.
   2. Under Application Servers, access the settings page.
   3. Click Java and Process Management. Click Class Loader.
   4. Click New.
   5. Select default Classes loaded with parent class loader first. Click OK.
   6. Click the auto-generated Class Loader ID.
   7. Click Shared Library References.
   8. Click Add, and select JDBCJAR. Click Apply.
   9. Save the changes.
4. Restart the application server.

Oracle WebLogic

Follow these steps:

Note: If you are using Oracle database, then do not perform the configurations that are mentioned in this section, because WebLogic supports Oracle database by default.

1. Copy the <Database_JAR> file to <Weblogic_JAVA_HOME>\lib\ext\.

   Here, <WebLogic_JAVA_HOME> represents the JAVA_HOME used by your Oracle WebLogic instance.

2. Log in to the 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 required <Database_JAR> file.
6. Click Next.
7. Click Next to display the Summary page.
8. Click Finish.
9. Activate the changes.
10. Restart the application server.

JBoss Application Server

Follow these steps:

1. Create a folder structure as <JBOSS_HOME>\modules\advauth-jdbc-driver\main\ and copy JDBC Jar file in this folder location.
2. Create a file in with the name module.xml at the following location: <JBOSS_HOME>\modules\advauth-jdbc-driver\main\
3. Add the following codes to the file:

   <?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>
   

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

   Example:sqljdbc.jar

5. Restart the application server.