Creating JDBC Providers

This task explains how to create internal JMS Servers:
  1. Log on to the WebSphere Administrator console using the default url <http://localhost:9090/admin>, unless the port number has changed. 
    The Login page is displayed.

  2. Enter the User ID, and then click OK. The Administration Console page is displayed.

  3. In the navigation pad, click Resources > JDBC Providers.

  4. Click New. The JDBC Providers page is displayed.

  5. From the JDBC Providers list, select Oracle JDBC Driver.

  6. Click Apply.

  7. The Additional Properties table is displayed in the JDBC Providers page. Scroll down to view this table.

  8. Click the link Data Source.

  9. In the Name and JNDI Name fields, enter EISDataSource.

  10. Click Apply. The Additional Properties table is displayed in Data Source page. Scroll down to view this table.

  11. In the Additional Properties table, click the link Custom Properties.

  12. Click the link URL, and then in the Value field, specify your database details.

  13. Click Apply, and save all the changes to the Master Configuration.

  14. Click Test Connection to verify whether you are able to connect to the database.