Oracle JDBC OCI Driver
Setting the Environment Variable for Oracle JDBC OCI Drivers
For Oracle JDBC OCI drivers, you must perform the following:
![*](chapterTOC_bullet.png)
Set the following environment variable before you configure the connection.
Platform | Environment Variable Setting |
Solaris* | LD_LIBRARY_PATH=/ORACLE_HOME/lib |
HP* | SHLIB_PATH=/ORACLE_HOME/lib |
AIX* | LIBPATH=/ORACLE_HOME/lib |
Linux | LD_LIBRARY_PATH=/ORACLE_HOME/lib |
![*](chapterTOC_bullet.png)
Check that the OCI client is configured correctly before you proceed.
Note:
*If you are using Oracle 920 JDBC driver files with an Oracle 920 client to connect to different Oracle database versions, set the environment variable for your platform to /ORACLE_HOME/lib32.
DataSource
Transaction Type | DataSource Class |
NO_TRANSACTION, LOCAL_TRANSACTION | oracle.jdbc.pool.OracleDataSource |
XA_TRANSACTION | oracle.jdbc.xa.client.OracleXADataSource |
Driver Type Setting
Specify the parameters in the Other Properties field:
Parameter | Description |
driverType | For Oracle JDBC OCI Driver version 8i: driverType=oci8 |
For Oracle JDBC OCI Driver version 9i: driverType=oci |
Other transaction type settings
![*](chapterTOC_bullet.png)
Adapter for JDBC supports the Oracle RAC TAF facility which provides failover support for Oracle v.9.2.x using an OCI driver. Under these circumstances you must use LOCAL_TRANSACTION connections.
Required Connection Property Fields
Driver Name | Server Name | User | Password | Database Name | Port Number | Network Protocol |
Oracle JDBC OCI Driver | Yes | Yes | Yes | Yes | Yes | Yes |
For more information about limitations, see
Limitations.