7.7.1.1 Create a JDBC Provider

To create the JDBC Provider in WebSphere Application Server, follow these steps:

1. Open the WebSphere admin console in the browser window:
   http://<ipaddress>:<administrative console port>/ibm/console (https, if SSL is enabled). The Login window is displayed.
2. Log in with the user ID that has admin rights.
3. Expand the Resources option in the LHS menu and click JDBC > JDBC Providers to display the JDBC Providers window.

   Figure 7-18 JDBC Providers

   
   

   

   
   
4. Select the Scope from the drop-down list. The Scope specifies the level at which the resource definition is visible.
5. Click New to add the new JDBC Provider under the Preferences section. The Create new JDBC Provider window is displayed.

   Figure 7-19 Create a new JDBC Provider

   
   

   

   
   
6. Enter the following details:
   1. Database Type: Oracle
   2. Provider Type: Oracle JDBC Driver
   3. Implementation Type: Connection pool data source
   4. Name: The required display name for the resource.
   5. Description: The optional description for the resource.
7. Click Next.

   Figure 7-20 Enter database class path information

   
   

   

   
   
8. Specify the directory location for the ojdbc<version>.jar file. Do not use the trailing slash file separators.
   The Oracle JDBC driver can be downloaded from the following Oracle Download site:

   • Oracle Database 18cg Release 3 JDBC Drivers
   • Oracle Database 19c Release 3 JDBC Drivers

   After downloading, you must copy the file in the required directory on the server.

   Note:

   See Hardware and Software Requirements to identify the correct ojdbc<version>.jar file version to be copied.
9. Click Next to display the Summary window.

   Figure 7-21 Summary

   
   

   

   
   
10. Verify the details and click Finish to create the JDBC Provider.
11. The options to Save and Review are displayed. Click Save.