Data source minimum required settings for Oracle
Set the appropriate properties on every data source configured. These settings are for Oracle data sources.
We 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:
- ojdbc6.jar or ojdbc5.0
Avoid trouble: 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 Version 6 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.
gotcha
- Requires the following DataStoreHelper class:
com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
Avoid trouble: We must use the Oracle11gDataStoreHelper with the ojdbc6.jar driver file, regardless of whether you use an Oracle 11g or Oracle 10g database server.gotcha
- 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
Avoid trouble: 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 Version 6 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.
gotcha
- Requires the following DataStoreHelper class:
com.ibm.websphere.rsadapter.Oracle11gDataStoreHelper
Avoid trouble: We must use the Oracle11gDataStoreHelper with the ojdbc6.jar driver file, regardless of whether you use an Oracle 11g or Oracle 10g database server.gotcha
- 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.
Related tasks
Configure a JDBC provider and data source Configure a JDBC provider using the administrative console Configure a data source using the administrative console Create 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