I have created a program that depends on the oracle JDBC driver, I have built it in Eclipse and added ojdbc14.jar to the build path. However when I want to run it from the command prompt it says it can’t find the oracledatasource (due to it not being in the classpath).
How do I add the ojdbc14.jar to the classpath on the command line so my runnable jar will work?
I have tried SET CLASSPATH=<dir> and when I type Set Classpath it actually comes up with the ojdbc.jar file however it still doesn’t run.
Paul Sturrock wrote:Do you mean set it from your Java program?
No I mean set it from the command prompt (as in Windows CMD). Basically my program relies on this ojbc14.jar file in order to compare databases. The idea is other users can download the ojdbc14.jar file from the oracle website, add this to the classpath from wherever they have it locally and run my program.