jdbc connection using thin driver

Question

i am connecting oracle 10g xe with java but getting the exception java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Even if i have included the classpath of driver i.e ojdbc14.jar
if i have set wrong classpath please tell me the correct way to set the classpath

Answer 1

note that running a JAR (double-click ou "java -jar file.jar") does not use the CLASSPATH environment variable

How Classes are Found

In that case - running a JAR - you must set the Class-Path attribute in the manifest file

JAR File Specification

Answer 2

I think you want to use oracle.jdbc.OracleDriver. I believe the oracle.jdbc.driver.OracleDriver was deprecated and removed between 9i and 10g.

Answer 3

That depends on how you are running your application. Normally you can set the classpath via the env var CLASSPATH, or the command-line-switch -cp.

Please provide more details of your environment.

Answer 4

If you are running your application as a Web Application in Tomcat, the ojdbc14.jar must be in, I believe, {tomcat_home}/server/lib. That or {tomcat_home}/common/lib... but I'm pretty sure it's server/lib.

Answer 5

I found it in a jar file called classes12.jar in oracle app server 9.0.4.