WAS v8.5 > Administer applications and their environment > Welcome to administering Data access resources > Administer data access applications > Configure a JDBC provider and data source

Create a data source that uses the Oracle JDBC Driver for OCI

We can use the Oracle JDBC for OCI with v8.5 of the Application Server.

To create a data source in the Application Server that takes advantage of the Oracle Call Interface (OCI), you might want to use the Oracle JDBC OCI driver. This JDBC provider can be configured with the Application Server.

  1. From the dmgr console, create the JDBC provider.

    1. Click Resources, expand JDBC, and click JDBC Providers.

    2. Select the scope for the JDBC Provider. The scope can be set to a cell, node, or server level.

    3. Click New to create the JDBC Provider.

  2. Configure the settings for the JDBC provider.

    1. Select Oracle for the database type on the Step 1: Create new JDBC provider panel.

    2. Select Oracle JDBC Driver for the provider type on the Step 1: Create new JDBC provider panel.

    3. Select Connection pool data source or XA data source for the implementation type on the Step 1: Create new JDBC provider panel.

    4. Specify a name and, optionally, a description, for the JDBC provider on the Step 1: Create new JDBC provider panel.

    5. Click Next.

    6. Specify a directory location for the ojdbc6.jar JAR file on the Step 2: Enter database class path information panel.

      Best practice: Application Server variables can be used in the class path or the native library path. For example, we can use variables like ${ORACLE_JDBC_DRIVER_PATH} and ${ORACLE_HOME} in the paths for the class path and native library path, but you must define the variables ORACLE_JDBC_DRIVER_PATH and ORACLE_HOME to the Application Server. Define or change the paths for these variables in the dmgr console by clicking Environment > Manage WebSphere Variables.

      Enter ${ORACLE_HOME}/lib where ORACLE_HOME is configured to the location in which Oracle Network client is installed. bprac

    7. Click Next.
    8. Review the configuration on the Summary panel and click Finish. If you must change the configuration, select the new configuration on the next panel, make your changes, and click Apply.

  3. Create the data source in WAS.

    1. Click Resources, expand JDBC, and click JDBC Providers > provider_name.

    2. Under Additional Properties, click Data sources > New.

    3. Specify the name for the data source on the Step 1: Enter basic data source information panel.

    4. Specify the JNDI name for the data source on the Step 1: Enter basic data source information panel.

    5. Click Next.

    6. Specify the URL of the database from which the data source obtains connections. Specify this information about the Step 2: Enter database-specific properties for the data source panel.

      For a thin driver:

        jdbc:oracle:thin:@//mySystem:1521/sample

      For a thick driver:

        jdbc:oracle:oci:@sample

    7. Select the name of the data store helper class that corresponds to the type of JDBC provider that you configured. Select this information about the Step 2: Enter database-specific properties for the data source panel.

    8. Click Next.

    9. Optional: Specify the values for the associated security aliases.

    10. Click Next.
    11. Review the configuration on the Summary panel and click Finish. If you must change the configuration, select the new configuration on the next panel, make your changes, and click Apply.

    12. Save the configuration.


Reference:

Data source minimum required settings for Oracle


+

Search Tips   |   Advanced Search