CA RiskMinder Windows Installation Guide › Configuring Application Server for Database Connection Pooling › Enabling Database Connection Pooling › IBM WebSphere

IBM WebSphere

This section provides the steps to enable IBM WebSphere for JNDI-based database operations. To configure an IBM WebSphere instance for deploying Java-dependent components of RiskMinder:

1. Log in to WebSphere Administration Console.
2. Select Resources and expand the JDBC node.
3. Click JDBC Providers.

   The JDBC Providers page appears.

4. In the Preferences section, click New to create an appropriate JDBC provider based on the database that you are using.

   The Create a new JDBC Provider page appears.

5. Perform the following tasks to create the JDBC Provider.

   Note: For more information, refer to:
   http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/topic/com.ibm.websphere.base.iseries.doc/info/iseries/ae/tdat_ccrtprov.html

6. Specify the Database Type and Provider Type.

   Select Connection pool data source from the Implementation Type drop-down list.

   1. Enter a Name for the JDBC provider. You can also enter a Description for the JDBC Provider.
   2. Click Next.

      The Enter database class path information screen appears.

   3. Enter the absolute path for the JAR file.
   4. Click Next.

      The Summary screen appears.

   5. After reviewing the summary of the information that you have entered, click Finish to complete the JDBC provider configuration.
7. Set the CLASSPATH for the JDBC provider that you created in Step 5.
   1. Click Resources and expand the JDBC node.
   2. Click JDBC Providers.

      The JDBC Providers page appears.

   3. Click the JDBC Provider that you created in Step 5.
   4. Set the Class Path for the JDBC JAR.
   5. Click Apply to save the changes.
8. Create a Data Source, as follows:
   1. Go to Resources, and then click JDBC.
   2. Under JDBC, open Data Sources and click New. Perform the following steps to create a data source:
   3. Specify the Data source name.
   4. Specify the JNDI name.

      Note: This name must match with the value of AppServerConnection PoolName.N in arcotcommon.ini.

   5. Click Next.
   6. Select an existing JDBC provider created in Step 3.
   7. Click Next.

      The Enter database specific properties for the data source screen appears.

   8. Depending on the database, enter the following information:
      • For Oracle:

        Specify the Value for JDBC URL. This URL would be of the following type:

           jdbc:oracle:thin:@<server>:<oracle_port>:<sid>
        

        Select the Data store helper class name.

      • For MS SQL Server:

        jdbc:sqlserver://<server>:<sql_port>;databaseName=<databasename>;selectMethod=cursor
        

      • For MySQL:

        jdbc:mysql://<server>:<port-number>/<database>
        

   9. Click Next.

      The Setup Security aliases screen appears.

   10. Click Next to view the Summary screen, and then click Finish.
9. Click the data source created in Step 8.
10. In the Related Items section, click JAAS - J2C authentication data.
11. Click New to create a new credential.
12. Enter login credentials that are used to connect to the database and save the credential.
13. Click Apply, and then click OK to save the changes made.
14. Click Data Sources and select the data source that you created in Step 8.
15. Under Security Settings -> Component-managed authentication alias, select the JAAS credential that you created in Step 12 and click Apply, and then OK.
16. Click Data Sources and select the check box for the data source you created in Step 8.
17. Click Test connection to verify that you have specified the connection correctly.

Note: This test only checks the connection to the database server, not necessarily the correct definition of the data source.