Installation Guide › How to Install CA GovernanceMinder on an IBM WebSphere Cluster › Install JDBC Drivers and Data Sources on the Workpoint Cluster › Install Oracle JDBC Drivers and Data Sources on the Workpoint Cluster

Install Oracle JDBC Drivers and Data Sources on the Workpoint Cluster

Valid on Oracle database.

This procedure describes how you install Oracle JDBC drivers and data sources on the Workpoint cluster.

Follow these steps:

1. Download the ojdbc14.jar file from the Oracle Download Center to the WebSphere application server, and place the file under the following directory:

   WAS_install_root/essentials/JDBC/
   

   Note: WAS_install_root is the WebSphere application server installation directory.

2. In the WebSphere administration console, click Resources, JDBC, JDBC Providers and create a JDBC provider with the following settings:
   • The server provider:

     Name: ServerProvider

     Provider Type: Oracle JDBC Driver

     Implementation Type: data source

   • The server XA provider:

     Name: ServerXAProvider

     Provider Type: Oracle JDBC Driver (XA)

     Implementation Type: XA data source

   • Apply the following settings to both JDBC providers:

     Scope – Workpoint_cluster

     Database type – Oracle

     Class path – WAS_install_root/essentials/JDBC/ojdbc14.jar

3. Restart the WebSphere Application Server or the Deployment Manager service as required in your WebSphere environment.

   The new data source definitions are implemented.

   You have installed the Oracle JDBC drivers and data sources on the Workpoint cluster.