Create a JNDI-based Database operations in IBM WebSphere

This section provides the steps to enable IBM WebSphere for JNDI-based database operations, including connection pooling, in CA Strong Authentication.
aa821test
This section provides the steps to enable IBM WebSphere for JNDI-based database operations, including connection pooling, in CA Strong Authentication.
Follow these steps
:
  1. Log in to WebSphere Administration Console.
  2. Click
    Resources
    and expand the
    JDBC
    node.
  3. Click
    JDBC Providers
    .
    The JDBC Providers page appears.
  4. In the
    Preferences
    section, click
    New
    .
    The Create a new JDBC Provider page appears.
  5. Perform the following steps to create a JDBC provider:
    See for more information about JDBC providers.
  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 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.
  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
      . This name must match with the AppServerConnectionPoolName.
      N
      in arcotcommon.ini.
    5. Click
      Next.
    6. Select the JDBC provider that you 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>
      jdbc:sqlserver://<server>:<sql_port>;databaseName=<databasename>;selectMethod=cursor
      Select the
      Data store helper class name
      .
    9. For Microsoft SQL Server:
    10. Click
      Next
      .
      The Setup Security aliases screen appears.
    11. Click
      Next
      to view the Summary screen, and then click
      Finish
      .
  8. Click the data source that you created in Step 7.
  9. In the
    Related Items
    section, click
    JAAS - J2C authentication data
    .
  10. Click
    New
    to create a credential.
  11. Enter login credentials that are used to connect to the database and save the credential.
  12. Click
    Apply
    , and then click
    OK
    to save the changes.
  13. Click
    Data Sources
    and select the data source that you created in Step 7.
  14. Under
    Security Settings
    ->
    Component-managed authentication alias
    , select the JAAS credential that you created in Step 11 and click
    Apply
    , and then
    OK
    .
  15. Click
    Data Sources
    and select the check box for the data source you created in Step 7.
  16. Click
    Test connection
    to verify that you have specified the connection correctly.
This test only checks the connection to the database server, not necessarily the correct definition of the data source.