CA RiskMinder UNIX Installation Guide › Deploying RiskMinder On a Single System › Performing Post-Installation Tasks › Preparing Your Application Server › Step 3: Copying JDBC JAR Files to Your Application Server

Step 3: Copying JDBC JAR Files to Your Application Server

RiskMinder 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 to one of the following application servers.

Apache Tomcat

To copy the JDBC JAR on Apache Tomcat:

1. Download the required JAR from any source.
2. Navigate to the location where you have downloaded the <Database_JAR> file.
3. 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/
4. Restart the server.

IBM WebSphere

To copy the JDBC JAR on IBM WebSphere:

1. Download the required JAR from any source, and then navigate to the location where you have downloaded it.
2. Log in to the WebSphere Administration Console.
3. Click Environment, and then click Shared Libraries.
   1. From the Scope list, select a valid visibility scope. The scope must include the target server or node on which the application is deployed.
   2. Click New.
   3. Enter the Name, say, 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 to save the changes that were made.
4. Configure server-level class loaders.
   1. Click Servers, and then click 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.
   5. Select default Classes loaded with parent class loader first and click OK.
   6. Click the auto-generated Class Loader ID.
   7. In the class loader Configuration page, click Shared Library References.
   8. Click Add, select JDBCJAR and then click Apply.
   9. Save the changes that were made.
5. Restart the application server.

Oracle WebLogic

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

If you are using Microsoft SQL Server or MySQL, to copy the JDBC JAR on Oracle WebLogic:

1. Download the required JAR from any source, and then navigate to the location where you have downloaded it..
2. Copy the Database_JAR file to Weblogic_JAVA_HOME/jre/lib/ext/.

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

3. Log in to the WebLogic Administration Console.
4. Navigate to Deployments.
5. Enable the Lock and Edit option.
6. Click Install and navigate to the directory that contains the required <Database_JAR> file.
7. Click Next to display the Application Installation Assistant page.
8. Click Next to display the Summary page.
9. Click Finish.
10. Activate the changes.
11. Restart the application server.

JBoss Application Server

To copy the JDBC JAR on JBoss Application Server:

1. Download the required JAR from any source, and then navigate to the location where you have downloaded it..
2. Copy the JDBC JAR file to the following location on the JBOSS installation directory:

   JBOSS_HOME/server/default/lib/
   

3. Restart the application server.