Subject: Re: JDBC OCI driver + Tomcat 4.04 From: "mark" <[EMAIL PROTECTED]> === When using the OCI driver in a windows environment, we have found the following helps :- 1) Add references to classes12.zip and nls_charset12.zip to the classpath (eg in catalina.bat). 2) The reference should be to the installed location (eg c:\oracle\Ora81\jdbc\lib\classes12.zip or wherever the zip files are in your oracle installation is). Do not copy to another location or rename to classes12.zip. 3) Make sure the oracle path has been added to the PATH variable in windows (again you can add it in catalina.bat).
The above steps dont seem necessary when using the Oracle thin driver and I'm not sure all of the above is required - it works for us though. Let us know if youre still having problems. HTH Mark "James Ward" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]... > One note I forgot to mention about the OCI driver: > > You must set your ORACLE_HOME and LD_LIBRARY_PATH vars!!! > In my server.sh I have these lines: > > ORACLE_HOME=/home/oracle/product/817 > export ORACLE_HOME > LD_LIBRARY_PATH=$ORACLE_HOME/lib > export LD_LIBRARY_PATH > > If you do all that and you can do a tnsping, everything *should* work. > > -James > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
