oracle database connection in java program

Question

 import java.sql.*;
 import java.io.*;

 public class OracleCon {


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

Class.forName("oracle.jdbc.OracleDriver");
    Connection con=DriverManager.getConnection("jdbc:oracle:thin@localhost:1521:xe", "system", "123456789");
Statement st=con.createStatement();
String sql="insert into citylist values ('vijay','54222','110001')";
int r=st.executeUpdate(sql);

if(r>0)
{
    System.out.print("value inserted");
}
else
{
    System.out.print("value not inserted");
}
//ResultSet rs=st.executeQuery(sql);

//while(rs.next())
//  System.out.println(rs.getString(1)+""+rs.getString(2)+""+rs.getString(3));
con.close();


  }
}

I have installed oracle 11g and jdk 1.8 at windows 7

Exception in thread "main" java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDriver at java.net.URLClassLoader.findClass(Unknown source) at java.lang.ClassLoader.loadClass (Unknown source)

SO rule is put exception here, in form of text

Jacek Cz
– Jacek Cz

2017-08-14 11:00:36 +00:00
Commented Aug 14, 2017 at 11:00 — Jacek Cz
– Jacek Cz, Commented Aug 14, 2017 at 11:00
Put the Oracle driver onto CLASSPATH...

Usagi Miyamoto
– Usagi Miyamoto

2017-08-14 11:03:56 +00:00
Commented Aug 14, 2017 at 11:03 — Usagi Miyamoto
– Usagi Miyamoto, Commented Aug 14, 2017 at 11:03
FYI: the two images are the same

Ivan
– Ivan

2017-08-14 11:11:23 +00:00
Commented Aug 14, 2017 at 11:11 — Ivan
– Ivan, Commented Aug 14, 2017 at 11:11

Mehdi Javan · Accepted Answer · 2017-08-14 12:32:18Z

2

When you run your program in Command Line, you must include the jar file path in front of classpath parameter like this:

java OracleCon -classpath c:\somepath\ojdbc6.jar

answered Aug 14, 2017 at 12:32

Mehdi Javan

1,0916 silver badges26 bronze badges

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

Comments

Matt · Accepted Answer · 2017-08-14 11:12:22Z

0

It could be that you are missing the actual jdbc driver for your Java version.

ojdbc6.jar from Oracle should do the trick for versions 6, 7 and 8.

Also don't forget to add the driver file to your classpath. If you are using Eclipse you can do that via right click on your project:

Properties > Java Build Path > Libraries

edited Aug 14, 2017 at 11:12

answered Aug 14, 2017 at 11:05

Matt

1166 bronze badges

Collectives™ on Stack Overflow

oracle database connection in java program

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