Add the JDBC Provider
- Select Resources>JDBC>JDBC providers.
- Select the scope of the server from the drop-down list.
Note: The drop-down list displays if the "Show scope selection drop-down list…" is checked.
- Click New.
- Select the Database type.
- For Oracle, select Oracle.
- For DB2, select DB2.
- Select the Provider type.
- For Oracle, select Oracle JDBC Driver.
- For DB2, select DB2 Universal JDBC Driver Provider.
- Select Implementation type.
- For Oracle, select XA data source.
- For DB2, select XA data source.
- Click Next.
- Enter the variable name used for the database driver.
- For Oracle, enter ${ORACLE_JDBC_DRIVER_PATH}
- For DB2, click Next.
- Click Finish
Note: For Oracle, skip steps 10 and 11. For DB2, continue at step 10.
- Click on the newly created JDBC provider.
- Confirm that the class path field is set to correctly reference the two DB2 drivers.
Refer to the examples below. Edit the field if needed.
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc.jar
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar
${DB2UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar
- Click OK.