Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

Question

I am new in java Jdbc I am going to write simple jdbc program `

   import java.sql.*;
   class jdbcDemo
     {
       public static void main(String[] args) throws Exception
        {
        Class.forName("oracle.jdbc.OracleDriver");
        Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","Scott","tiger");
        Statement st=con.createStatement();
        ResultSet rs=st.executeQuery("select * from rk");
    while(rs.next())
    {
        System.out.println(rs.getInt(1)+"---"+rs.getString(2)+"---"+rs.getInt(3));
    }
    con.close();
    }
 }

after Successful compiling program At runtime i found following error

click here runtime error snapshot

I had used editplus editor and also i had created rk table in oracle 12c database

need help to fix issue

did you add oracle driver to the classpath?

lakshman
– lakshman

2017-08-09 04:21:23 +00:00
Commented Aug 9, 2017 at 4:21 — lakshman
– lakshman, Commented Aug 9, 2017 at 4:21

Rishi Goel · Accepted Answer · 2017-08-09 04:22:30Z

2

You need to provide the class for oracle driver. It will be in a jar which needs to be in class path. Since you are running from command prompt, this needs to be passed to run the class successfully.

answered Aug 9, 2017 at 4:22

Rishi Goel

6804 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mehrdad Yami · Accepted Answer · 2017-08-09 04:37:08Z

0

As you load class of oracle driver in your code :

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

you just need to add oracle jdbc drivers(ojdbc6 or ojdbc7 ) into your project . you can download this jar file from thislink : JDBC DOWNLOAD LINK

answered Aug 9, 2017 at 4:37

Mehrdad Yami

1,6911 gold badge14 silver badges26 bronze badges

Collectives™ on Stack Overflow

Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.OracleDriver

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related