Installation Guide › Installing an AIX Implementation › Install and Configure Workpoint Components on AIX/WebSphere › Install Oracle JDBC Drivers and Data Sources on the Workpoint Cluster

Install Oracle JDBC Drivers and Data Sources on the Workpoint Cluster

The Java Database Connectivity (JDBC) API supports server cluster connections to the database. When an Oracle database server hosts CA RCM databases, you install JDBC drivers on the WebSphere Application Server.

Distributed transactions are handled using XA data sources. To allow a specific user to participate in distributed transactions with the JDBC driver, assign the user the SqlJDBCXAUser role for the database.

To install Oracle JDBC drivers and data providers in the CA RCM cluster

1. Download the ojdbc14.jar file from the Oracle Download Center to the WebSphere application server. 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:
3. In the WebSphere Application Server administration console, select Resources, JDBC, JDBC Providers and create JDBC providers with the following settings:
   • For the server provider:

     Name: ServerProvider

     Provider Type: Oracle JDBC Driver

     Implementation Type: data source

   • For 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 – CA RCM cluster
   • Database type – Oracle
   • Class path – WAS_install_root/essentials/JDBC/ojdbc14.jar
4. Restart the WebSphere Application Server or the Deployment Manager service as required in your WebSphere environment to implement the new data source definitions.