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

You can use the Oracle JDBC for OCI with Version 6.x of the Application Server.

About this task

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.

Procedure

  1. From the administrative console, create the JDBC provider.
    1. Click Resources > JDBC Providers.
    2. Select the scope for the JDBC Provider. The scope can be set to a cell, node, or server level.
    3. Click Apply.
    4. Click New to create the JDBC Provider.
  2. Configure the settings for the JDBC provider.
    1. In the Configuration tab, under General Properties, configure the settings for an Oracle JDBC driver.
      1. In Step 1: Select the database type, select Oracle from the list.
      2. In Step 2: Select the provider type, select Oracle JDBC Driver from the list.
      3. In Step 3: Select the Implementation type, select Connection pool data source or XA data source from the list.
      4. Click Next.
    2. Specify a name and, optionally, a description, for the JDBC provider.
    3. Enter database class path and native library path information.
      Best practice: Application Server variables can be used in the class path or the native library path. For example, you 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 administrative console by clicking Environment > Manage WebSphere Variables .bprac
      1. In the class path field, enter the following:
        ${ORACLE_JDBC_DRIVER_PATH}/ojdbc14.jar
      2. In the native library field, enter the following:
        ${ORACLE_HOME}/lib
        where ORACLE_HOME is configured to the location in which Oracle Network client is installed.
    4. Click Apply.
  3. Create the data source in Application Server.
    1. Click Resources > JDBC providers > provider_name > Data sources > New .
    2. Enter the name for the data source.
    3. Enter the JNDI name for the data source.
    4. Select the name of the data store helper class that corresponds to the type of JDBC provider that you configured.
    5. Select Component-managed authentication alias and enter the database specific properties for the data source.
    6. For the URL, enter the URL for the data source. For example:
      jdbc:oracle:oci:@<tnsname_alias>
      The value for <tnsname_alias> must be defined in the ${ORACLE_HOME}/network/admin/tnsnames.ora file.
    7. Click OK and save the configuration.



In this information ...


IBM Redbooks, demos, education, and more

(Index)

Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

Task topic    

Terms of Use | Feedback

Last updated: Aug 29, 2010 6:22:59 PM CDT
http://www14.software.ibm.com/webapp/wsbroker/redirect?version=vela&product=was-express-dist&topic=tdat_oraclerac
File name: tdat_oracleoci.html