have you set the enoviornment variable if not then beacuse of this the dri

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 / amit singh

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

Answer Posted / amit singh

have you set the enoviornment variable if not then beacuse
of this the driver can not be load
because which you path
Class.forName
("oracle.jdbc.driver.OracleDriver");
in Class.forName("String" )
compiler search it out in bin/lib of jre or jre bin/lib/ext
so please check it out because of it this excption commonly
come
because if some one used Mysql and i did in past i got thsi
exception because it didn't set the Classpath for connection.jar
so do it getridof this thing
thanks
amitsing2008@gmail.com
amit09mca

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are jdbc and its components?

966

What are the differences between statement and preparedstatement interface?

974

Explain the main method?

1035

What is new in JDBC 2.0?

1014

How do you determine the sensitivity of the ResultSet object?

981

What is use of connection pooling?

954

Is jdbc open source?

848

What is JDBC Statement?

983

How will you perform truncation using JDBC?

994

What are the differences between execute, executequery, and executeupdate?

942

How do we load the drivers?

992

What do you understand by jdbc statements?

1016

How to rollback a JDBC transaction?

1084

Does sql allow null values ?

954

Which type of driver provides jdbc access via one or more odbc drivers?

898