Oracle JDBC Thin Driver

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 driver-dependent parameters based on the JDBC driver and the transaction type that the connection is using in the Other Properties field:

Parameter	Description
driverType	For example: driverType=thin

Kerberos Authentication

Specify the Kerberos authentication parameters in the Other Properties field in the following format:

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

where <kerberoscache_file_path> is the path to the file that has the stored ticket.

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 watt property if it does not exist.

For information on creating truststore aliases, refer to the webMethods Integration Server Administrator’s Guide.

Required Connection Property Fields

Driver Name	Server Name	User	Password	Database Name	Port Number	Network Protocol
Oracle JDBC Thin Driver	Yes	Yes	Yes	Yes	Yes	No

For more information about limitations, see Limitations.