Data source minimum required settings for Oracle

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

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.

      Avoid trouble: Be aware of the following:

      • Oracle does not support the use of ojdbc14.jar in an environment with the Java™ SE Development Kit V6 or later.

      • In mixed node environments, the data source wizard in the admin console allows you to choose a class path for ojdbc6.jar or ojdbc14.jar.

      • For Oracle trace, use ojdbcversion_g.jar.

  • Requires the following DataStoreHelper class:

    com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
    

    Avoid trouble: Use the Oracle11gDataStoreHelper with the ojdbc6.jar driver file, regardless of whether you 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.

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

      • Oracle does not support the use of ojdbc14.jar in an environment with the Java SE Development Kit V6 or later.

      • In mixed node environments, the data source wizard in the admin console allows you to choose a class path for ojdbc6.jar or ojdbc14.jar.

      • For Oracle trace, use ojdbcversion_g.jar.

  • Requires the following DataStoreHelper class:

    com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
    

    Avoid trouble: Use the Oracle11gDataStoreHelper with the ojdbc6.jar driver file, regardless of whether you use an Oracle 11g or Oracle 10g database server.

  • Requires a valid authentication alias.

  • Requires properties:

    URL

    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.

---

 

Related tasks

Set a JDBC provider and data source
Set a JDBC provider
Set a data source
Create and configuring a JDBC provider and data source using the Java Management Extensions API

 

Related

Oracle Technology Network - SQLJ/JDBC Download Page