postgresql classpath under windows

Question

I'm running this under windows vista cmd prompt:

java -classpath C:\postgresql-8.4-701.jdbc4.jar -jar myJar.jar

I get the error:

Cannot load postgresql driver. org.postgresql.Driver

The line causing the error is:

Class.forName("org.postgresql.Driver");

But in eclipse, the program works, and the postgresql library is referenced under the "Referenced Libraries".

How to fix this please ? I need to run the program under the windows cmd prompt while getting the same result I get in Eclipse IDE.

Do a jar -tf and confirm that it contains the org.postgresql.Driver class in it. — Kal
– Kal, Commented Jul 28, 2011 at 3:29
Find the jar file that you are using in Eclipse .. and replace this current one with that. — Kal
– Kal, Commented Jul 28, 2011 at 3:36

Kal · Accepted Answer · 2011-07-28 03:46:47Z

1

I think this has to do with the fact that since you are using an executable jar, the classpath variable is being ignored.

You should make sure that your myJar.jar has the correct classpath entries in its manifest file using

Class-Path: postgres...jar

Make sure that its in the same directory as myJar.jar

answered Jul 28, 2011 at 3:46

Kal

24.9k8 gold badges67 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

To be precise: when using java -jar all other classpath definitions are ignored. That is also documented in the tools manual (see the last line for the -jar option): download.oracle.com/javase/6/docs/technotes/tools/windows/…