Add the JDBC Provider

  1. Select Resources>JDBC>JDBC providers.
  2. 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.

  1. Click New.
  2. Select the Database type.
    • For Oracle, select Oracle.
    • For DB2, select DB2.
  3. Select the Provider type.
    • For Oracle, select Oracle JDBC Driver.
    • For DB2, select DB2 Universal JDBC Driver Provider.
  4. Select Implementation type.
    • For Oracle, select XA data source.
    • For DB2, select XA data source.
  5. Click Next.
  6. Enter the variable name used for the database driver.
    • For Oracle, enter ${ORACLE_JDBC_DRIVER_PATH}
    • For DB2, click Next.
  7. Click Finish

Note: For Oracle, skip steps 10 and 11. For DB2, continue at step 10.

  1. Click on the newly created JDBC provider.
  2. 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

  1. Click OK.

 

 

 

Oracle Insurance Logo Copyright © 2017, Oracle and/or its affiliates. All rights reserved. About Oracle Insurance | Contact Us