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
JDBC provider:
- Supports the following one phase data source:
- oracle.jdbc.pool.OracleConnectionPoolDataSource
- Requires the following JDBC driver files:
- ojdbc14.jar. If you require Oracle trace, use ojdbc14_g.jar.
- Requires the following DataStoreHelper class:
- com.ibm.websphere.rsadapter.OracleDataStoreHelper
- Oracle 10g: com.ibm.websphere.rsadapter.Oracle10gDataStoreHelper
- Requires a valid authentication alias.
- Requires the following 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.
This JDBC provider:
- Supports the following two phase data source:
- oracle.jdbc.xa.client.OracleXADataSource
- Requires the following JDBC driver files:
- ojdbc14.jar. If you require Oracle trace, use ojdbc14_g.jar.
- Requires the following DataStoreHelper class:
- com.ibm.websphere.rsadapter.OracleDataStoreHelper
- Oracle 10g: com.ibm.websphere.rsadapter.Oracle10gDataStoreHelper
- Requires a valid authentication alias.
- Requires the following 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 for OCIThe Oracle JDBC Driver provides JDBC access to the
Oracle database that uses the Oracle Call Interface (OCI).