Oracle

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.

DataSource

oracle.jdbc.pool.OracleDataSource

oracle.jdbc.xa.client.OracleXADataSource

Driver Type Setting

Specify the parameters in the Other Properties field:

driverType=oci8

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

DataSource

oracle.jdbc.pool.OracleDataSource

oracle.jdbc.xa.client.OracleXADataSource

Driver Type Setting

Specify the driver-dependent parameters based on the JDBC driver and the transaction type that the connection is using in the Other Properties field:

driverType=thin

Universal Connection Pooling

initialPoolSize=<INITIAL_POOL_SIZE>;minPoolSize=<MIN_POOL_SIZE>;
maxPoolSize=<MAX_POOL_SIZE>;inactiveConnectionTimeout=<INACTIVE_CONNECTION_TIMEOUT>;
maxConnectionReuseTime=<MAX_CONNECTION_REUSE_TIME>

url=jdbc:oracle:thin:@(DESCRIPTION=(CONNECT_TIMEOUT=90)(RETRY_COUNT=50)(RETRY_DELAY=1)
(TRANSPORT_CONNECT_TIMEOUT=90)(ADDRESS_LIST=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)
(HOST=<oracle_server_host>)PORT=<port>)))CONNECT_DATA=SERVICE_NAME=<sid>)));
ConnectionFactoryClassName=oracle.jdbc.replay.OracleDataSourceImpl;initialPoolSize=5;
minPoolSize=10;maxPoolSize=20;inactiveConnectionTimeout=60;maxConnectionReuseTime=6

For more information about the Oracle versions supported and JARs to upload, see IBM webMethods Adapters System Requirements.

Kerberos Authentication

connectionProperties={
oracle.net.authentication_services=(KERBEROS5),
oracle.net.kerberos5_mutual_authentication=true,
oracle.net.kerberos5_cc_name=<kerberoscache_file_path>}

Synonym Support

Specify the following property to enable synonym support in the Other Properties field:

connectionproperties={includeSynonyms=true}

SSL Setting

• If you have configured SSL connections between Adapter for JDBC and Oracle server, enter the TCPS port number of the Oracle server.
• If you have configured SSL connections between Adapter for JDBC and Oracle server, enter tcp or tcps in the Network Protocol field.
• If you have configured SSL connections between Adapter for JDBC and Oracle server, set the truststore alias name in the watt.server.ssl.trustStoreAlias property.
  • In Integration Server Administrator, select Settings > Extended.
  • Set the property, watt.server.ssl.trustStoreAlias to the truststore alias name created in Integration Server. Add the configuration parameter if it does not exist.
  For information on creating truststore aliases, refer to the IBM webMethods Integration Server Administrator’s Guide.

Required Connection Property Fields

DataSource

com.wm.dd.jdbcx.oracle.OracleDataSource

Required Connection Property Fields

DataSource

oracle.jdbc.pool.OracleDataSource

oracle.jdbc.xa.client.OracleXADataSource

Driver Type Setting

Specify the driver-dependent parameters based on the JDBC driver and the transaction type that the connection is using in the Other Properties field:

driverType=thin

Other Properties

Specify the following properties in the Other Properties field:

(retry_count=20)

(retry_delay=3)

(service_name=xxx.adb.oraclecloud.com)

(ssl_server_dn_match=yes)

TNS_ADMIN="C:\\XXX\\Wallet_XXXX"

url=jdbc:oracle:thin:@(description=(retry_count=20)(retry_delay=3)
(address=(protocol=tcps)(port=1522)(host=adb.aaa-xxx.oraclecloud.com))
(connect_data=(service_name=sss.adb.oraclecloud.com))
(security=(ssl_server_dn_match=yes)))?TNS_ADMIN="C:\\XXX\\Wallet_XXXX"

Required Connection Property Fields