Adapter for JDBC 10.3 | webMethods Adapter for JDBC Documentation | webMethods Adapter for JDBC Installation and User’s Documentation | JDBC Driver Specific Properties | Oracle | Oracle JDBC OCI Driver
 
Oracle JDBC OCI Driver
Setting the Environment Variable for Oracle JDBC OCI Drivers
For Oracle JDBC OCI drivers, you must perform the following:
*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
*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
*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.