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
- 24903 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 an odbc driver?
What do you mean by odbc?
how can connection with oracle10g with java
Does the database server have to be running Java or have Java support in order for my remote JDBC client app to access the database?
What are the different types of 2 tier and 3 tier architecture ?
What is the major difference between java.util.date and java.sql.date data type?
any one can explain about policy file rule? when i connect database with applet then ther is no compile time error but the run time error is occureed.i.e access is denied.policy file rule is related to this problem.
How do we load the drivers?
Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?
How many types of jdbc drivers are there?
Explain Basic Steps in Writing a Java Program Using Jdbc?
What is the difference between ExecuteUpdate and ExecuteQuery?
Core Java 
