Create the Oracle JNDI data source

Before you begin

Before proceeding, complete Create the Oracle JDBC provider.

Procedure

  1. Open the WebSphere Administrative Console if not already open.
  2. If you do not yet have a J2C (Java 2 Connector) authentication alias, create a new one.
    1. Click Security > Global security.
    2. Under Authentication click Java Authentication and Authorization > J2C authentication data.
    3. Click New.
    4. Enter the following:

      Parameter

      Value

      Alias

      A string specifying the alias name. The alias can be anything you like, for example pcAlias.

      User ID

      A string specifying the user name.

      Password

      A string specifying the password.
    5. Click OK.
    6. Click Save to apply your changes to the master configuration.
  3. Choose Resources > JDBC > JDBC Providers.
  4. Set the Scope to Cell.
  5. Select the JDBC provider that you defined for Oracle.
    WebSphere displays the Configuration tab.
  6. Select Data Sources in the Additional Properties section.
    WebSphere displays the Data sources screen.
  7. Click New to create a new data source.
  8. Enter a JNDI name for the data source.

    The JNDI name must match the value of the datasource-name attribute of the <jndi-connection-pool> element in file database-config.xml. See Using a JNDI data source.

  9. Click Next.
  10. Set the URL value using the jdbc:oracle:thin:@hostname:port:ORACLE_SID format.
  11. Select Oracle11g data store helper for the Data store helper class name.
  12. Click Next.
  13. Select an authentication alias for the Component-managed authentication alias.
  14. Select an authentication alias for the Container-managed authentication alias.
  15. Click Next.
  16. Review the information on the Summary screen and do one of the following:
    • Click Previous if you need to make changes.
    • Otherwise, click Finish.
  17. Click Save to apply your changes to the master configuration.

What to do next

After completing this procedure, proceed to Configure the Oracle data source properties.