I have installed a third party java webservice which uses Oralce jdbc thin driver to write data into Oracle database. When i run this, i get the following error;

JDBC Driver class not found: oracle.jdbc.OracleDriver

I have oracle installed and set classpath variable to following value:

*D:\oracle\product\10.2.0\client_1\jdbc\lib\classes12.jar;D:\oracle\product\10.2.0\client_1\jdbc\lib\classes12.zip;D:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14.jar;D:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14.zip;C:\Program Files\Java\jdk1.7.0\jre\lib\rt.jar*

and path variable to following value;

*D:\oracle\product\10.2.0\client_1\bin;C:\Program Files\Java\jdk1.7.0\bin\;D:\oracle\product\10.2.0\client_1\jdbc\lib\classes12.jar;D:\oracle\product\10.2.0\client_1\jdbc\lib\classes12.zip;D:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14.jar;D:\oracle\product\10.2.0\client_1\jdbc\lib\ojdbc14.zip*

Any suggestion why web service is not able to identify jdbc driver?

Thanks

解决方案

I know 2 ways of turning Java app into Windows service and both do not use CLASSPATH. One is Java Service Wrapper by Tanuki Software. This tool uses wrapper.conf where you can show directories with .jar libraries:

# Java Classpath (include wrapper.jar) Add class path elements as

# needed starting from 1

wrapper.java.classpath.1=c:\jars\*

wrapper.java.classpath.2=myservice.jar

Second tool I know is JSL: Java Service Launcher. In this tool there is jsl.ini where you put command line to run your server. It can use java with -cp option to show location of .jar libraries:

[defines]

MY_LIBS=d:\jars\*

AXIS_LIBS=d:\axis2-1.5.4\lib\*

CLASSPATH=.;%MY_LIBS%;%AXIS_LIBS%

export = CLASSPATH

...

[java]

...

cmdline = -Dfile.encoding=utf8 -cp %CLASSPATH% example.my.server

In both configuration you can use * to add all .jar files or you can show those files one by one (just like in CLASSPATH).

At first you should know what Windows is trying to execute. Check it in the service properties page. Then try to localize its configuration. If it uses one of tools I know then you know what to change. Other tools probably have similar configuration.