Interested to Buy Any Domain ? << Click Here >> for more details...
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");
}
}
}
- 6 Answers
- 25087 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / mohit
i hav faced same problem...
still i didnt get right answere
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / deepak
just find the file named classes.jar in the oracle installed
directory.and copy the full address of classes.jar with the
file name and goto command prompt and write the
(this is for oracle 11g)
c:\>set
classpath=D:\app\Deepak\product\11.2.0\dbhome_1\oui\jlib\classes12.jar;.;
this sets ur classpath teprorily for that session
now run the command for checking that the classpath is seted
properly.
c:\>java oracle.jdbc.driver.OracleDriver
Exception in thread "main" java.lang.NoSuchMethodError: main
if this is shown then now u can run ur program.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / 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 |
Answer / vishnu
iam usin type 4 driver .using oracle 10g.when i am trying to run the code error came like this Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.
OracleDriver.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / vijay
Hey,
You are written In valid Driver name
use following script
Then you can't get that problam.
Class.forName("oracle.jdbc.Driver.OracleDriver");
in Driver "D" should capital
| Is This Answer Correct ? | 1 Yes | 16 No |
what is the difference between SENSITIVE and INSENSITIVE?
What is the latest version of JDBC? What new features are added?
What is jdbc odbc connection?
What is executequery in java?
commit() and rollback() methods are defined in which interface?
List the common jdbc exceptions ?
What are the advantages of using preparedstatement in java?
What is connection pooling? What Method and class used for Connection pooling in Java?
What is in term of jdbc a datasource?
What is the use of getGeneratedKeys() method in Statement?
What is sqlwarning and discuss the procedure of retrieving warnings?
How can you know about drivers and database information ?
Core Java 
