How do we install OCI driver for JDBC

Hi,

what is the procedure for installing the OCI driver for the JDBC adapter. The manual does talk about it. But then it also talks about the client being correctly configured. Where do we configure that. Also it talks about setting an environment variable. But nothing has been mentioned for windows.

We have been using the thin driver successfully for some time. However To insert large clobs we are forced to use the OCI drivers. Are there any problems with OCI and thin co-existing on windows.

We use is 6.0.1 SP2

Thanks in advance

Hi,

Oracle suggests to install Complete Oracle Client to use OCI Driver. OCI Driver is part of classes111.zip and classes12.zip. (same files, which contain thin drivers.). Just that OCI depends on Local Oracle Client.

Regards,

Chirag.

Thanks chirag.
It also mentions that a particular environment level be updated. However there is no information in the WmJDBC users guide for the windows system. Do we have to set anything.

Also while configuring the connection what do we setup in the other properties. Driver type = oci or oci8

SB,

Set in the OtherProperties:driverType=oci and also copy the classes111.zip in the IS classpath(IS/lib/jars)folder,restart IS.

HTH,
RMG.

On your server do we have to set anything as below. What would be the value for windows
for other os the values are metioned in the users guide

Solaris* LD_LIBRARY_PATH=/ORACLE_HOME/lib
HP* SHLIB_PATH=/ORACLE_HOME/lib
AIX* LD_LIBRARY_PATH=/ORACLE_HOME/lib
Linux LD_LIBRARY_PATH=/ORACLE_HOME/lib

It also mentions that a particular environment level be updated. However there is no information in the WmJDBC users guide for the windows system. Do we have to set anything.

SB,

I dont think there are any extra settings on OS level,just follow the settings as mentioned above.

Anyways search in this site for any missing information.

goodluck,

see this link,regarding configuration and settings
http://www.wmusers.com/wmusers/messages/117/36050.shtml