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

Issue

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.

Solution

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

Answered By - Alisa
Answer Checked By - Mildred Charles (JavaFixing Admin)