Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What do I need to do to get my script to find JDBC driver?

966239Feb 13 2015 — edited Feb 17 2015

I’m trying to run the following java script. I’m getting the following error.

import java.sql.DriverManager;

import java.sql.Connection;

import java.sql.SQLException;

public class OracleJDBC {

    public static void main(String[] argv) {

        System.out.println("-------- Oracle JDBC Connection Testing ------");

        try {

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

        } catch (ClassNotFoundException e) {

            System.out.println("Where is your Oracle JDBC Driver?");

e.printStackTrace();

return;

        }

        System.out.println("Oracle JDBC Driver Registered!");

        Connection connection = null;

        try {

            connection = DriverManager.getConnection(

"jdbc:oracle:oci:@testeorad001.test.com:1521:CMItstA", "ODCtest",

"ODCtest");

        } catch (SQLException e) {

            System.out.println("Connection Failed! Check output console");

e.printStackTrace();

return;

        }

        if (connection != null) {

System.out.println("You made it, take control your database now!");

} else {

System.out.println("Failed to make connection!");

}

}

}

-------- Oracle JDBC Connection Testing ------

Where is your Oracle JDBC Driver?

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

at java.net.URLClassLoader$1.run(URLClassLoader.java:200)

at java.security.AccessController.doPrivileged(Native Method)

at java.net.URLClassLoader.findClass(URLClassLoader.java:188)

at java.lang.ClassLoader.loadClass(ClassLoader.java:307)

at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)

at java.lang.ClassLoader.loadClass(ClassLoader.java:252)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:169)

at OracleJDBC.main(OracleJDBC.java:13)

Do you know what I’d have to do to access the JDBC driver?

This post has been answered by unknown-7404 on Feb 13 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 17 2015
Added on Feb 13 2015
6 comments
1,581 views