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. You 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. Oracle JDBC Driver supports one phase data source:

   oracle.jdbc.pool.OracleConnectionPoolDataSource
  

  Requires JDBC driver files: ojdbc14.jar. (Note: If you require Oracle trace, use ojdbc14_g.jar.) Requires DataStoreHelper class:

  com.ibm.websphere.rsadapter.OracleDataStoreHelper

  (Note: If you are running Oracle10g, use com.ibm.websphere.rsadapter.Oracle10gDataStoreHelper.)

  Requires a valid authentication alias. Requires properties:

  • URL The URL that indicates the database from which the data source obtains connections. Example: jdbc:oracle:thin:@myServer:1521:myDatabase, where myServer is the server name, 1521 is the port it is using 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. Oracle JDBC Driver (XA) supports two phase data source:

  oracle.jdbc.xa.client.OracleXADataSource
  

  Requires JDBC driver files: ojdbc14.jar. (Note: If you require Oracle trace, use ojdbc14_g.jar.) Requires DataStoreHelper class:

  com.ibm.websphere.rsadapter.OracleDataStoreHelper

  (Note: If you are running Oracle10g, use com.ibm.websphere.rsadapter.Oracle10gDataStoreHelper.)

  Requires a valid authentication alias. Requires properties:

  • URL The URL that indicates the database from which the data source obtains connections. Example: jdbc:oracle:thin:@myServer:1521:myDatabase, where myServer is the server name, 1521 is the port it is using for communication, and myDatabase is the database name.

Related tasks

Reference topic