I have tried that I got this C:\connection>java oracle.jdbc.driver.Or

java.lang.ClassNotFoundException:oracle.jdbc.driver.OracleDr
iver? I get this error at run time.I used oracle10G. I set
CLASS PATH:C:\oraclexe\app\oracle\product\10.2.0
\server\jdbc\lib\ojdbc14.jar;
I write JDBC PROGRAM like
import java.sql.*;

class Example
{
public static void main(String args[])
{
try
{
Class.forName
("oracle.jdbc.driver.OracleDriver");
System.out.println("Driver Loaded");
Connection con=DriverManager.getConnection
("jdbc:oracle:thin:@localhost:1521:xe","system","salmas");
System.out.println("Driver Connected");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from
emp");
while(rs.next())
{
System.out.println(rs.getInt(1));
System.out.println(rs.getString(2));
System.out.println(rs.getString(3));
}
st.close();
con.close();
}

catch(Exception e)
{
System.out.println(e);
}

finally
{
System.out.println("it's
finally block executed");
}

}
}

Question Posted / renuka

6 Answers
25305 Views
CTS, I also Faced
E-Mail Answers

Answer Posted / renuka

I have tried that I got this

C:\connection>java oracle.jdbc.driver.OracleDriver
Exception in thread "main" java.lang.NoSuchMethodError: main

but still my program is not running. I am getting the
following error

C:\connection>java -classpath . getOracleConnection
Exception in thread "main" java.lang.NoClassDefFoundError:
oracle/jdbc/OracleDri
ver
at DB.dbConnect(getOracleConnection.java:26)
at getOracleConnection.main(getOracleConnection.java:10)
Caused by: java.lang.ClassNotFoundException:
oracle.jdbc.OracleDriver
at java.net.URLClassLoader$1.run(Unknown Source)
at
java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at
sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the ddl statements?

913

What are different types of JDBC Drivers?

1260

Why do we need jdbc?

1109

How to know howmuch data is truncated?

2418

Why prepared statements are faster?

1016

How do I know which jdbc driver to use?

1069

What is device controller?

1146

Why is odbc needed?

959

What are the differences between setmaxrows(int) and setfetchsize(int)?

1111

What are the utilities of the callablestatement?

1062

How can we store and retrieve images from the database?

1010

What are the advantages of using jdbc datasource?

1026

Why should we close database connections in java?

1197

What is odbc and jdbc in dbms?

1010

How can I get information about foreign keys used in a table?

1008