1. Transaction Server Reference Guide for UNIX using WebSphere Application Server
  2. Using JDBC Store

Using JDBC Store

To use JDBC Store:

  1. Login to WAS admin console.

  2. Select Resources ->JDBC ->Data Sources from left panel of the console and choose the cluster scope.

    This image is described in surrounding text.

  3. Click New and navigate to Create Data Source screen

    This image is described in surrounding text.

  4. Enter the Data Source name and JNDI name as shown in below screen shot and click Next

    This image is described in surrounding text.

  5. Select "Create new JDBC provider and click Next as shown in below screen

    This image is described in surrounding text.

  6. Fill in all the details as shown in the below screen shot and proceed to next screen clicking Next

    Note: Other Database types may be selected and similar configuration parameters may be selected.
    This image is described in surrounding text.

  7. Give the directory location for ojdbc6.jar as seen in the below screen shot and Click Next.

    Note: This is a typical example for using Oracle database. For other database similar type 4 JDBC driver location is provided.
    This image is described in surrounding text.

  8. Fill in the appropriate URL for the database from which the data source obtains the connection and data store helper class name as shown in below screen shot and click the Next button.

    The URL should be similar to this:

    jdbc:oracle:thin:@localhost:1521:sample" for thin driver

    Note: The URL for other databases will differ.
    This image is described in surrounding text.

  9. Click the Next button on setup security aliases screen as you would lose your current wizard selections by setting them up now. This can be set later.

    This image is described in surrounding text.

  10. Click Finish and navigate to the Create data sources screen.

    This image is described in surrounding text.

  11. Select the newly created Datasource and navigate to Test connection screen

    This image is described in surrounding text.

  12. On this screen select JAAS -J2C authentication data under "Related Items" as shown in below screen shot.

    This image is described in surrounding text.

  13. Select the New button.

    This image is described in surrounding text.

  14. Fill in appropriate values for all the fields of this screen as shown in below screen where User ID specifies the J2C authentication data for database connection.

    This image is described in surrounding text.

  15. Click the OK button to save changes to master configuration.

    This image is described in surrounding text.

  16. Again select the data source from top of this screen as shown below.

    This image is described in surrounding text.

  17. Go back to Data Source screen by clicking on the data source name from top of the screen.

  18. On this screen chose the security settings newly created as shown in below screen shot and click the OK button.

    This image is described in surrounding text.

  19. Save changes to master configuration.

    This image is described in surrounding text.

  20. Check the newly created data source and click the Test Connection button.

    This image is described in surrounding text.

  21. If prompted, save changes to master configuration, then synchronize the changes and repeat the above step.

  22. The test connection should be successful.

    This image is described in surrounding text.

  23. Repeat the steps in this section to create any number of data sources in the cluster scope.