how to setup jdbc classpath for oracle 9i

[kallis kals]

hai everybody,
Iam using oracle 9i as Database and by using TYPE 4 driver of JDBC I want to get connected to Oracle 9i . So by doing so , Iam getting an ERROR (unable to find "oracle.jdbc.driver.OracleDriver").

so can any body help in resolving this problem (i.e) how to set classpath etc etc


Thank you....

[George Stoianov]

Hi Kallis,

The message you have posted means that your java program when being compiled or when running cannot find the driver make sure your driver is on the class path or path depending on what operation system you are using. If your code compiles OK then it is the later and if you are using windows ... do check the environment variables and the Path variable in particular your driver should be located somewhere on the path or this is not going to work.

Thanks.
George

[emm raha]

Add Oracle's driver path to your classpath when compiling. If you're compiling from the command line:

javac -cp %CLASSPATH%;c:\temp\classes12.jar YourApp.java

[kallis kals]

Thanks everyone in helping me in setting classpath.