Data source minimum required settings for Oracle

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

You can configure the following types of providers:
  • 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:
      • ojdbcversion.jar
        Avoid trouble: For Oracle trace, use ojdbcversion_g.jar.
    • Requires the following DataStoreHelper class:
      com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
      Avoid trouble: You must use the Oracle11gDataStoreHelper for database server versions 11g and later.
    • 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:
      • ojdbcversion.jar
        Avoid trouble: For Oracle trace, use ojdbcversion_g.jar.
    • Requires the following DataStoreHelper class:
      com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
      Avoid trouble: You must use the Oracle11gDataStoreHelper for database server versions 11g and later.
    • 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.