Creating the Oracle JDBC provider

About this task

To establish access to your Oracle database you must create a JDBC provider for Oracle access.

To create the JDBC provider complete the following steps:

Procedure

  1. Select Resources > JDBC > JDBC Provider.
  2. Select Scope and choose the one which has Node and Server.
  3. Click New.
  4. Specify the JDBC provider information
    Database type
    Set to Oracle.
    Provider Type
    Set to Oracle JDBC Driver.
    Implementation type
    Set to Connection Pool datasource.
  5. Click Next.
  6. The Class path is already pre-populated as ${ORACLE_JDBC_DRIVER_PATH}/ojdbc6.jar. The directory location for ${ORACLE_JDBC_DRIVER_PATH} to the jar files must be correct. This can be obtained from the Oracle server installation or downloaded from the Oracle website. For example, C:\app\Administrator\product\11.2.0\dbhome_1\jdbc\lib. Click Next.
  7. Click Finish.
  8. Click Save.