Create the Oracle JDBC provider

Before you begin

Before starting this procedure, complete Copy the Oracle JDBC driver to WebSphere.

Procedure

  1. Open the WebSphere Administrative Console if not already open.
  2. Choose Resources > JDBC > JDBC Providers.
  3. Set the Scope to Cell.
  4. Click New to create a new JDBC provider.
  5. Select Oracle for the Database type.
  6. Select Oracle JDBC Driver for the Provider type.
  7. Select Connection pool data source for the Implementation type.
  8. Supply a new Name for the JDBC provider, for example pcOracle.
  9. Enter a Description for the JDBC provider if you want.
  10. Click Next.
  11. Specify the directory location of ojdbc-<version>.jar.

    Set the value to the WAS_HOME/lib/ext path in which you copied ojdbc-<version>.jar earlier.

  12. Click Next.
  13. Review the Summary screen and do one of the following:
    • Click Previous if you need to make changes.
    • Otherwise, click Finish.
  14. Click Save to apply your changes to the master configuration.
    WebSphere returns you to the JDBC Providers screen. At this point, you have completed the creation of the new provider.

What to do next

After completing this procedure, proceed to Create the Oracle JNDI data source.