Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to setup jdbc classpath for oracle 9i

 
kallis kals
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 94
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks everyone in helping me in setting classpath.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic