Network Deployment (Distributed operating systems), v8.0 > Reference > Sets

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 you 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. Be aware of the following:
      • Oracle does not support the use of ojdbc5.jar in an environment with the Java SE Development Kit v6 or later.

      • In mixed node environments, the data source wizard in the administrative console allows you 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
    

    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 Be aware of the following notes regarding the use of these driver files:
      • Oracle does not support the use of ojdbc5.jar in an environment with the Java SE Development Kit v6 or later.

      • In mixed node environments, the data source wizard in the administrative console allows you 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
    

    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
    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
Configure a JDBC provider and data source using the JMX API
Create a data source that uses the Oracle JDBC Driver for OCI

Related

Oracle Technology Network - SQLJ/JDBC Download Page

+

Search Tips   |   Advanced Search