Hi,I am having trouble setting the classpath for my Driver class. I have a simple database program that registers a driver class org.postgresql.Driver in the function - Class.forname().The class file is defined in a jar file pgdev.307.jdbc3.jar, which is in the directory c:\postgre. On Extracting the jar file, I get the following directory structure: C:\postgre\org\postgresql\Driver.class
I have tried to set the classpath as: set classpath=C:\postgre\pgdev.307.jdbc3.jar but on running the program, I get : java.lang.ClassNotFoundException rg.postgresql.Driver
Can someone please help me with the problem.
[edited to disable smilies] [ November 02, 2004: Message edited by: Jeanne Boyarsky ]
Are you running a stand-alone allication or in an application server or some other configuration?
I ask since app servers ignore the classpath so you could set it to whatever you wanted and it wouldn't make a difference to the server!
If you're in a servlet container, it's typically best to drop your jar in the WEB-INF/lib directory. The container will then find and load the jar file contents for you.
If you're using a stand-alone application, try using the javap command to test your classpath. ie type javap org.postgresql.Driver and see if it works. You can then play with your classpath to get it right without having to worry about your code.