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
24928 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

How to check jdbc connection in linux?

976

What is data source in java?

907

What is jdbc odbc driver?

993

What is ojvm used for?

943

What does connection pooling mean ?

945

What do you understand by jdbc statements?

981

How to know howmuch data is truncated?

2327

Write an sql to find all records having all numeric characters in a field ?

918

What is isolation level? How to set it?

2135

What is jdbc and its types?

908

What is the benefit of having jdbcrowset implementation? Why do we need a jdbcrowset like wrapper around resultset?

917

What does jdbc do?

969

What do you understand by jdbc datasource?

968

Explain about column name and getter method?

1021

Explain in detail about JDBC and its general features?

917