Reputation: 83

Java JDBC Connection ClassNotFoundException Error

I am a beginner in java and have a problem in connection of JDBC connections I get a "java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver" Error running the code. here's my source code

 import java.sql.*;
    public class Connect 
    {
        public static void main(String[] args) 
        {
            try
            {
                Class.forName("oracle.jdbc.OracleDriver");
                System.out.println("Drivers Loaded");
                Connection con = DriverManager.getConnection("jdbc:oracle:thin:SYSTEM/rambabu@localhost:8081:XE");
                System.out.println("Connection established");
                con.close();
            }
            catch(Exception e)
                {
                    System.out.println(e);
                }
    }
}

Upvotes: 2

Answers (5)

ChadNC

Reputation: 2503

In the projects menu, right click on the libraries folder, select add jar/folder, then select the ojdbc jar and it will be added to the projects library and you should be able to use the drivers.

Try something simple like the following to test the connection

Connection conn = null;
try{
  DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
  conn = DriverManager.getConnection("dburl","username", "password");
  if(conn != null){
    System.out.println("Connection to Phoenix unsuccessful");
  }else{
    System.out.println("Connection to Phoenix successful");
  }

}catch(SQLException e){
  System.out.println("Exception creating DB connection: " + e);
  for(StackTraceElement ste : e.getStackTrace())
    System.out.println(ste.toString());
}

Upvotes: 0

EvenLisle

Reputation: 4812

It could be that the .jar-file containing the jdbc-driver is not in the "referenced libraries". If you're developing in Eclipse, you can just right click the project > Build path > configure build path > Libraries tab > add external jars > locate and add your version of the jdbc driver.

Hope it helps.

Upvotes: 0

Kumar Vivek Mitra

Reputation: 33544

Try it this way....

public class DataBaseClass {

    Connection conn;

    public void receivedConnection() {



        try {
            conn = getConnection();
            System.out.println("I GOT THE CONNECTION");



        } catch (SQLException e) {

            System.out.println("I DID NOT GET THE CONNECTION");
            e.printStackTrace();
        }

        try {

            Statement stat = conn.createStatement();
            stat.executeUpdate("DROP TABLE VIVEK_DA_TABLE");
        } catch (SQLException e) {
            System.out.println("Table didnt exist");
            //e.printStackTrace();
        }

    }


    public static Connection getConnection() throws SQLException{

        String drivers = "com.mysql.jdbc.Driver";
        String url    = "jdbc:mysql://localhost:3306/test";
        String username = "root";
        String password = "vicky";

        System.setProperty(drivers,"");
        return DriverManager.getConnection(url,username,password);

    }

    public static void main(String[] args) throws SQLException{

        DataBaseClass db = new DataBaseClass();
        db.receivedConnection();
    }

}

Upvotes: 0