Class Path Issue with jar execution

[Jigar Gohil]

Hi,
I am trying to execute a jar with classpath configuration via bat file:

set JAVA_HOME=C:\wls11g\jdk1.6.0_24

set CLASSPATH=.;lib\classes12.zip;

%JAVA_HOME%\bin\java -jar -Dxign.config.properties=config\config.properties -Dxign.security.properties=config\security.properties Demo-App.jar input.csv output_log 500

-- Projects
-- Projects\run_app.bat
-- Projects\Demo-App.jar
-- Projects\lib\classes12.zip

Issue: It is not able to load the classes12.zip. I checked with -verbose. I even tried with complete path instead of relative path.

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
        at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:169)
        at com.migration.startup.DBMigrator.getConnection(DBMigrator.ja
        at com.migration.startup.DBMigrator.startMigration(DBMigrator.j
        at com.migration.startup.DBMigrator.main(DBMigrator.java:685)

[Dave Tolls]

When running an executable jar file the CLASSPATH environment variable is not used.
It only uses the classpath as defined in the Manifest.

And...how old is your Oracle instance?
classes12.zip has not been the driver for must be close to 15 years now.

[Jigar Gohil]

Dave Tolls wrote:When running an executable jar file the CLASSPATH environment variable is not used.
It only uses the classpath as defined in the Manifest.

And...how old is your Oracle instance?
classes12.zip has not been the driver for must be close to 15 years now.

Thanks Dave, for quick reply

Oracle 10g and classes12 works for it when I use it with independent class file. My problem is when i package that file in a jar and try to refer it from outside.

- Is there a way by which I can keep the dependent jar outside and set it in the classpath? Like here I do not want to keep the classes12 as part of my App jar and wants to refer it from outside.

Regards,
Jigar

[Paul Clapham]

Jigar Gohil wrote:Is there a way by which I can keep the dependent jar outside and set it in the classpath? Like here I do not want to keep the classes12 as part of my App jar and wants to refer it from outside.

Yes, like Dave said you put the class path into the executable jar's manifest. I'd suggest you read through the Oracle tutorial about jar files to get the necessary background -- https://docs.oracle.com/javase/tutorial/deployment/jar/

[Dave Tolls]

Jigar Gohil wrote:
Oracle 10g and classes12 works for it when I use it with independent class file.

You should be using the version of the JDBC driver that applies to your version of Oracle, and/or your version of Java.
This is the Oracle page for 10g (release 2).
Unless you are using a pre-1.4 version of Java you should be on a much much newer version of the driver.