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");
}
}
}
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
What is database deadlock ?
What is ODBC and JDBC? How do you connect the Database?
What are the main steps in java to make JDBC connectivity?
What are the jdbc statements?
What is a JDBC 2.0 DataSource?
What is the major difference between java.util.date and java.sql.date data type?
Explain the two tier and three tier architecture of jdbc.
What does the connection object represents?
How a database driver can be loaded with jdbc 4.0 / java 6?
Explain the locking system in jdbc?
How do I check in my code whether a maximum limit of database connections have been reached?
Which type of driver provides jdbc access via one or more odbc drivers?
What are the utilities of the callablestatement?
Does jdbc require oracle client?
What are the benefits of PreparedStatement over Statement?