Oracle Driver not found? Classpath is set, JAR/JDBC file file is compatible

Question

IMPORTANT: I am not using any 3rd party apps, just java 1.8 (32-bit), Oracle 10G express edition, notepad, and Command prompt.

I am facing an error:

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
        at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:349)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
        at java.lang.Class.forName0(Native Method)
        at java.lang.Class.forName(Class.java:264)
        at OracleCon.main(OracleCon.java:5)

My OracleCon.java file:

import java.sql.*;
public class OracleCon{
    public static void main(String[] a) {
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");    //exception is here
            //other part of code
        }  catch (Exception e) {
            e.printStackTrace();
        }
    }
}

I have done following stuff:

Set JAVA_HOME as path in system environment variable.
Removed oracle path for java in system: C:\ProgramData\Oracle\Java\javapath
Copied ojdbc14 and ojdbc14_g ".jar" file found at C:\oraclexe\app\oracle\product\10.2.0\server\jdbc\lib, pasted at C:\Program Files (x86)\Java\jre1.8.0_202\lib\ext
Compiled and executed, failed!
Set CLASSPATH as ojdbc/jar file in jre lib folder.
Compiled and executed, failed!
Copied those ojdbc/jar files and pasted those in my folder where this OracleCon.java file is located in.
Compiled and excuted, and failed!
Tried installing those ojdbc/jar files from internet (javatpoint).
Uninstalled and reinstalled java (jdk and jre), and oracle.
Downloaded ojdbc8.jar, copied-pasted same in different folders!

Note: I had closed and re-opened Command Prompt after each step!

I'm not sure what `ojdbc14` and `ojdbc14_g` are, but the JDBC driver files will have a `.jar` suffix, so they are not it. You will need to be much more explicit about what you did: "Set classpath as ojdbc file in jre lib folder" tells us nothing. — tgdavies, May 08 '22 at 07:34
A JDBC driver is just a jar. You need to put it in the classpath, just like you would for any other library. — Olivier, May 08 '22 at 07:40
@Olivier I had copied-pasted those jar file in `jre/lib/ext`, that didn't work so used "Set classpath" method — rushabhvg, May 08 '22 at 07:49
What exact `java` command line did you use at step 5? Please answer by editing your question rather than in a comment. — tgdavies, May 08 '22 at 07:49
@tgdavies java OracleCon, I had compiled OracleCon.java file before it. I use Windows 11 laptop — rushabhvg, May 08 '22 at 07:50
Set claspath = C:\Program Files (x86)\Java\jre1.8.0_202\lib\ext\ojdbc14.jar;.; — rushabhvg, May 08 '22 at 07:53
Exact command is: `Set classpath = C:\Program Files (x86)\Java\jre1.8.0_202\lib\ext\ojdbc14.jar;.;` — rushabhvg, May 08 '22 at 08:04
@StephenC that didn't work too! My command `set CLASSPATH = C:\Program Files (x86)\Java\jre1.8.0_202\lib\ext\ojdbc14.jar;.;` — rushabhvg, May 08 '22 at 08:07
Well ... there are other problems. I'm not 100% familiar with Windows, but shouldn't the value be quoted? And the final `;` should not be there. — Stephen C, May 08 '22 at 08:08
And I am not convinced that `ojdbc14.jar` is the correct driver JAR for Java 8. According to https://www.oracle.com/au/database/technologies/faq-jdbc.html you should be using `ojdbc8.jar`. (ojdbc14 is the JAR for Java 1.4 ...) — Stephen C, May 08 '22 at 08:12
That doesn't work too! I tried putting it in quotes too! Removed that `;` and `.;` as 2 different commands with those — rushabhvg, May 08 '22 at 08:13
@StephenC I tried downloading ojdbc8.jar file and setting it as classpath. But it doen't work! — rushabhvg, May 08 '22 at 08:26
You really shouldn't put stuff in `lib/ext`, that extension mechanism is even removed in more recent Java versions. — Mark Rotteveel, May 08 '22 at 12:19

Oracle Driver not found? Classpath is set, JAR/JDBC file file is compatible

0 Answers0