jdbc ClassNotFoundException even after having ojdbc6.jar

Question

When I run the code I get ClassNotFoundException.I thought it was because of ojdbc6.jar file.I downloaded the file from Oracle and copied the file to my subdirectory from where I am running the code on command line.However, I am still getting the error.Can anyone help me understanding what am I doing wrong?

are you compiling class including jar ? – bananas Feb 22 '17 at 04:57 — bananas, Feb 22 '17 at 04:57
Add the `ojdbc6.jar` to your `CLASSPATH` and retry. – N00b Pr0grammer Feb 22 '17 at 06:30 — N00b Pr0grammer, Feb 22 '17 at 06:30
Please post code and console output as text, not as images. – Mark Rotteveel Feb 22 '17 at 12:13 — Mark Rotteveel, Feb 22 '17 at 12:13

score 4 · Accepted Answer · answered Feb 22 '17 at 06:41

You're having this problem because the class file that you try to run depends on a jar file called ojdbc6.jar. First , you need to compile both, the jar file and the class file.

1) First put your jar file in the same directory where you have your java code.

2) Then compile both, jar and java file:

javac -cp ".:/path_of_jar_file_found_using_pwd/ojdbc6.jar" MyJavaFile.java

3) Now run both as:

java -cp ojbdc6.jar:. MyJavaFile

This should work on mac/linux or other unix based system.For windows, replace : by ; .

score 1 · Answer 2 · edited May 23 '17 at 12:25

1

From where are you running your program? From the screenshot, I can see that you are running it from terminal

Use the below command to run it from the terminal supplying the necessary jars which includes them in classpath for this particular run.

java -cp "Test.jar;lib/*" my.package.MainClass

If you want the necessary jars, you can set the classpath variable in windows by the below command and add necessary jars to the existing classpath variable

SET CLASSPATH = %CLASSPATH%;Test.jar;C:/username/Test1.jar

And then, you can run the java program normally

java SimpleInsert

If you are using an IDE like eclipse, NetBeams, you have to set up your build path and external jars in your build path.

Refer this post for more information Setting multiple jars in java classpath

edited May 23 '17 at 12:25

Community

1
1

answered Feb 22 '17 at 07:04

ShankarDaruga

164
1
5

I'm running it on mac which is unix like. So how do I set classpath for that? I think mac command for this should be similar to Linux. Although I already accepted some else's answer, if you can answer this I will upvote your answer.And thank you in advance. – Kalia Dona Feb 22 '17 at 07:11
And also what is java -cp "lib/*" ? By Test,jar, do you mean my ojdbc6.jar file? And my.package.MainClass , do you mean .java file? – Kalia Dona Feb 22 '17 at 07:14
I'm not sure about Mac, but in unix, you can use this `export CLASSPATH = $CLASSPATH:/home/user/ojdbc6.jar:/lib/*` before running your program. And.. java -cp "lib/*" will add all the jar files present in /lib folder. This is useful if you are using more jars. You can place them in the lib folder (or any folder of your choice ) and add all the jar present in that folder with the above wildcard use "lib/*" – ShankarDaruga Feb 22 '17 at 09:07

N00b Pr0grammer · Answer 3 · 2017-02-22T09:57:40.083

As mentioned in my comment earlier, you might consider adding ojdbc6.jar to your CLASSPATH variable or you might add this jar under your %JAVA_HOME%\jre\lib\ext folder so that the extension classloader will be able to load the necessary class file.

SET CLASSPATH = %CLASSPATH%;C:/JARS/ojdbc6.jar;

You can easily check whether the necessary class is part of your Application using CTRL + SHIFT + T, as it identifies classes from added JARs as well.

Hope this helps!

score 0 · Answer 4 · answered Dec 05 '20 at 18:36

0

Right-click on warning message --> Quick Fix;
Select the option Mark the associated raw classpath entry as a publish/export dependency. (in the following figure)

answered Dec 05 '20 at 18:36

santi000001

21
4

jdbc ClassNotFoundException even after having ojdbc6.jar

4 Answers4