CA Adapter Windows Installation Guide › Deploying and Configuring State Manager › Creating a JNDI Connection › IBM WebSphere

IBM WebSphere

To create a JNDI connection in IBM WebSphere:

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

   The JDBC Providers page opens.

4. In the Preferences section, click New.

   The Create a new JDBC Provider page opens.

5. Perform the following steps to create a JDBC provider:

   Note: Refer to http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/topic/com.ibm.websphere.base.iseries.doc/info/iseries/ae/tdat_ccrtprov.html for more information on JDBC providers.

   1. If you are using MS SQL Server or Oracle, perform the following steps:
      • Specify the Database Type and Provider Type.
      • Select Connection pool data source from the Implementation Type drop-down list.
   2. If you are using MySQL, perform the following steps:
      • Specify User-Defined as the Database Type.
      • Specify the following as the Implementation Class Name:

        com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource

   3. Enter a Name for the JDBC provider. You can also enter a Description for the JDBC provider.
   4. Click Next.

      The Enter database class path information screen opens.

   5. Enter the absolute path for the JAR file.
   6. Click Next.

      The Summary screen opens.

   7. After reviewing the summary of the information that you have entered, click Finish.
6. 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 opens.

   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.
7. 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: The value you enter in the JNDI name field must exactly match the "Primary JNDI Name" that you have configured in the AFM wizard.

   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 opens.

   8. Depending on the database, enter the following information:
      • For MS SQL Server:

        Specify the Database name, Port number, and Server name.

      • For Oracle:

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

        jdbc:oracle:thin:@server:port_number:sid

   9. Select the Data store helper class name. For MySQL, ensure that the data store helper class name is com.ibm.websphere.rsadapter.GenericDataStoreHelper.
   10. Click Next.

       The Setup Security aliases screen opens.

   11. Click Next to view the Summary screen, and then click Finish.
8. Click the data source created in Step 7.
9. If you are using MS SQL Server or Oracle, perform the following steps:
   1. In the Related Items section, click JAAS - J2C authentication data.
   2. Click New to create a new credential.
   3. Enter login credentials that are used to connect to the database and save the credential.
   4. Click Apply, and then click OK to save the changes made.
   5. Click Data Sources and select the data source that you created in Step 7.
   6. Under Security Settings -> Component-managed authentication alias, select the JAAS credential that you created in earlier and click Apply, and then OK.
10. If you are using MySQL, perform the following steps:
    1. Click the Custom Properties link.

       A screen showing the existing custom properties opens.

    2. Click New, and enter values for the following properties:
       • databaseName

         Enter a value in the dbname?autoReconnect=true format.

       • user
       • password
       • port

         Enter 3306 for MySQL.

       • serverName
    3. Log in again to WebSphere Administration Console.
    4. Go to Resources, and then click JDBC.
11. Click Data Sources and select the check box for the data source you created in Step 7.
12. 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. On MySQL, if you find that the connection test fails even though you have specified the correct connection parameters, restart the application server and then retry the connection test.