"java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver" error when running from terminal

Question

I have a program that I run from Eclipse successfully.

However, when I want to run it from terminal, I encounter the famous error:

"java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver"

on this line:

Class drvClass = Class.forName("oracle.jdbc.driver.OracleDriver");

PS:

I have the following in CLASSPATH:

/oracle/jdbc/lib/ojdbc6.jar

Also note that I compile it successfully (javac Test2.java). Then when I run it (java Test2), I get the following error:

Error: Could not find or load main class Test2

So I run:

java -classpath ~/Desktop/JDBC2/src Test2

It runs, but I get the above "ClassNotFoundException" though.

Yes, if you mean when running: java -classpath ~/Desktop/JDBC2/src Test2 — Alisa
– Alisa, Commented Oct 20, 2015 at 4:42
So try -classpath ~/Desktop/JDBC2/src:/oracle/jdbc/lib/ojdbc6.jar, for example. You need both in the classpath, and like I said, -classpath is overriding your CLASSPATH variable. — yngwietiger
– yngwietiger, Commented Oct 20, 2015 at 4:46

Ishmael MIRZAEE · Accepted Answer · 2015-10-20 06:54:58Z

1

I found this question tricky: the reason is related to semicolon after jar file address. At first I changed the directory of MySample.java to another directory (you can don't do that) like C:\ then I removed package address from the source code, at the end I run this command in cmd

java -cp path_to_oracle_driver.jar; MySample

P.S. If you want run it from terminal you have to remove package PackageAddress from the source code and compile it again.

answered Oct 20, 2015 at 6:54

Ishmael MIRZAEE

1,25015 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Alisa · Accepted Answer · 2015-10-21 15:55:26Z

1

As @yngwietiger mentioned above in the comments, using -classpath parameter when running the .class file, overrides the original CLASSPATH and the predefined ojdbc6.jar file. So we need to mention both when running:

java -classpath ~/Desktop/JDBC2/src:/oracle/jdbc/lib/ojdbc6.jar Test2

Or, as a better solution, we can add the current path to CLASSPATH (note the colon and dot at the end):

export CLASSPATH=$CLASSPATH:.

And, in order to run, we just need to type:

Java Test2

edited Oct 21, 2015 at 15:55

answered Oct 20, 2015 at 5:21

Alisa

3,1423 gold badges35 silver badges45 bronze badges

1 Comment

Satyam Patil Over a year ago

you missed ';' at the end of .jar

Collectives™ on Stack Overflow

"java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver" error when running from terminal

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related