CODEWITHSUNDEEP
javaoracle-databaseclasspathjdbc
pratap
pratap

Reputation: 131

jdbc connection using thin driver

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

Upvotes: 1

Views: 1677

Answers (5)

Kevin Williams
Kevin Williams

Reputation: 2613

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

Upvotes: 0

Anonymous
Anonymous

Reputation:

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.

Upvotes: 0

Nathan Feger
Nathan Feger

Reputation: 19496

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

Upvotes: 1

user85421
user85421

Reputation: 29680

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

Upvotes: 1

sleske
sleske

Reputation: 83609

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.

Upvotes: 0

Related Questions