Adding JDBC Providers for Oracle

You must add JDBC Providers to WebSphere for the database. The instructions in this section apply to both Oracle databases.

  1. On the left side of the console, click Resources.

    Additional options appear.

  2. Expand JDBC.
  3. Click JDBC providers.
  4. From the All scopes list, select Node=<server_name><node_number>, Server=server1.
  5. Click New.

    The Create a new JDBC Provider screen appears.

  6. From the Database type list, select Oracle.
  7. In the Provider type list, select Oracle JDBC Driver.
  8. From the Implementation type list, select XA data source.
  9. Click Next.
  10. Specify the path to the JDBC driver file, as follows:

    • Oracle: In the Directory location text box, type the path to the ojdbc8.jar file you downloaded in About the Driver File for Oracle. Be sure to use forward slashes (/) in your path, even on a Windows system.

  11. Click Next.
  12. Review the summary.
  13. Click Finish.