Data source minimum required settings for Oracle

These properties vary according to the database vendor requirements for JDBC driver implementations. We must set the appropriate properties on every data source that we configure. These settings are for Oracle data sources.

We can configure the following types of providers:

• Oracle JDBC Driver
• Oracle JDBC Driver (XA)

• Oracle JDBC Driver

  The Oracle JDBC Driver provides JDBC access to the Oracle database. This JDBC driver supports both Type 2 JDBC access and Type 4 JDBC access.

  This provider:

  • Supports one-phase data source:

    oracle.jdbc.pool.OracleConnectionPoolDataSource
    

  • Requires the following JDBC driver files:
    • ojdbc6.jar or ojdbc5.0

      Be aware of the following:

      • Oracle does not support the use of the JDBC 4.0 APIs that are part of the Java SE Development Kit v6 or later when using ojdbc5.jar
      • In mixed node environments, the data source wizard in the administrative console allows us to choose a class path for ojdbc6.jar or ojdbc5.jar.

      • For Oracle trace, use ojdbcversion_g.jar.

  • Requires the following DataStoreHelper class:

    com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
    

    We must use the Oracle11gDataStoreHelper with the ojdbc6.jar driver file, regardless of whether we use an Oracle 11g or Oracle 10g database server.

  • Requires a valid authentication alias.
  • Requires properties:

    URL

    The URL that indicates the database from which the data source obtains connections. For example:

    jdbc:oracle:thin:@//myServer:1521/myDatabase
    

    where myServer is the server name, 1521 is the port that the server uses for communication, and myDatabase is the database name.

• Oracle JDBC Driver (XA)

  The Oracle JDBC Driver (XA) provides XA-compliant JDBC access to the Oracle database. This JDBC driver supports both Type 2 JDBC access and Type 4 JDBC access.

  This provider:

  • Supports two-phase data source:

    oracle.jdbc.xa.client.OracleXADataSource
    

  • Requires the following JDBC driver files:
    • ojdbc6.jar or ojdbc5.0

      Be aware of the following notes regarding the use of these driver files:

      • Oracle does not support the use of the JDBC 4.0 APIs that are part of the Java SE Development Kit v6 or later when using ojdbc5.jar
      • In mixed node environments, the data source wizard in the administrative console allows us to choose a class path for ojdbc6.jar or ojdbc5.jar.

      • For Oracle trace, use ojdbcversion_g.jar.

  • Requires the following DataStoreHelper class:

    com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
    

    We must use the Oracle11gDataStoreHelper with the ojdbc6.jar driver file, regardless of whether we use an Oracle 11g or Oracle 10g database server.

  • Requires a valid authentication alias.
  • Requires properties:

    URL

    Indicates the database from which the data source obtains connections. For example:

    jdbc:oracle:thin:@//myServer:1521/myDatabase
    

    where myServer is the server name, 1521 is the port that the server uses for communication, and myDatabase is the database name.

Configure a JDBC provider and data source

Configure a JDBC provider

Configure a data source

Create and configure a JDBC provider and data source using the JMX API

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

Oracle Technology Network - SQLJ/JDBC Download Page