Home » Developer & Programmer » JDeveloper, Java & XML » ClassNotFoundException(oracle.jdbc.driver.OracleDriver)
ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #90840] Mon, 01 October 2001 02:13 Go to next message
Vijayalakshmi.L
Messages: 1
Registered: October 2001
Junior Member
Hi
I am trying to connect to oracle database on the server, oracle client installed on working m/c, I have placed classes111.zip (from oracle 8) in jdk1.1.8demojrelibext folder and I have set the classpath to the ext folder. The code
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(Exception e)
{
}

when I run this code , error as
[[ java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver ]]

Please reply what are settings I should to to load this oracle driver,
1) Should I download any drivers and install in my m /c
2) Is that classes111.zip is correct ?



----------------------------------------------------------------------
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #90841 is a reply to message #90840] Thu, 04 October 2001 07:16 Go to previous messageGo to next message
Jughead
Messages: 1
Registered: October 2001
Junior Member
Try using classes12.zip.

----------------------------------------------------------------------
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #90848 is a reply to message #90840] Wed, 10 October 2001 02:54 Go to previous messageGo to next message
Yuva
Messages: 3
Registered: October 2001
Junior Member
Try using this!!!

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

reply

----------------------------------------------------------------------
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #90939 is a reply to message #90840] Tue, 18 December 2001 11:24 Go to previous messageGo to next message
Sudheer Parasker
Messages: 1
Registered: December 2001
Junior Member
If you still didn't find solution for this problem, try this....
1. unzip classes111.zip in the directory (demojrelibext).
2. while running, run as java -classpath "give the same classpath as you have given for javac" example1
Hope this helps.

----------------------------------------------------------------------
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #91285 is a reply to message #90848] Tue, 02 July 2002 07:06 Go to previous messageGo to next message
cinsia
Messages: 1
Registered: July 2002
Junior Member
when I use:
Class.forName("oracle.jdbc.driver.OracleDriver");
I got:
ClassNotFoundException(oracle.jdbc.driver.OracleDriver) error;
when I use:
"Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");"
I got:
"java.sql.SQLException: No suitable driver" error;

~~~~~~~~~~~>_<~~~~~~~~~~~
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #91290 is a reply to message #90848] Tue, 02 July 2002 23:18 Go to previous messageGo to next message
SKS
Messages: 26
Registered: February 2002
Junior Member
If you are using
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@100.0.9.0:1521:abc","user","password");

Then you put classes12.zip in your class path
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #92020 is a reply to message #91285] Wed, 04 February 2004 03:32 Go to previous messageGo to next message
Raghavendra Kamath
Messages: 2
Registered: February 2004
Junior Member
OracleDriver.class not found when deploying JSP page through Oracle Jdeveloper 9.0.3
Re: oracle.jdbc.driver.OracleDriver [message #92021 is a reply to message #91285] Wed, 04 February 2004 03:33 Go to previous messageGo to next message
Raghavendra Kamath
Messages: 2
Registered: February 2004
Junior Member
Can't access OracleDriver.class, when deploying JSP page through Oracle Jdeveloper 9.0.3
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #92164 is a reply to message #91285] Tue, 30 March 2004 19:56 Go to previous messageGo to next message
Biswajit Jena
Messages: 3
Registered: March 2004
Junior Member
Hello,
When i am going to connect the Oracle database the following exception is occured.

ClassNotFoundException(oracle.jdbc.driver.OracleDriver)

please give me the solution.

Thanks & Regards
Biswajit
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #92165 is a reply to message #92164] Tue, 30 March 2004 20:21 Go to previous messageGo to next message
abdul
Messages: 18
Registered: May 2001
Junior Member
ur Drivere for JDBC is not set set the path of Classes.jar in the PATH of the system
No error and Empty record found [message #92167 is a reply to message #92165] Wed, 31 March 2004 01:21 Go to previous messageGo to next message
Biswajit Jena
Messages: 3
Registered: March 2004
Junior Member
Hello,
This is my simple code and getting empty value when i am executing.
please let me know the problems.

1.My oracle server name is IBMSERVER
2.Database GAD
3.Username/Password :GADDEV/GADDEV respectively.why it's not working through this driver.



import java.sql.*;

public class orcl
{
public static void main(String args[[]])
{
Connection conn = null;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
// Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

conn = DriverManager.getConnection(
"jdbc:oracle:thin:@192.168.100.12",
"gaddev",
"gaddev");

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM EI_Emp_MH");

while(rs.next())
{

System.out.println(rs.getString("EMP_M"));
}

}catch(SQLException e)
{
e.getMessage();
}
catch(ClassNotFoundException e)
{
System.out.println("ClassNotFoundException: " + e.getMessage());
}

finally {

if(conn != null)
{
try {
conn.close();
}
catch (Exception ignored) {}
}
}

}

}

With regards
Biswajit
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #92570 is a reply to message #90848] Mon, 20 September 2004 00:15 Go to previous messageGo to next message
Venkat
Messages: 110
Registered: February 2001
Senior Member
Check whether OracleDrivers are installed properly
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #92623 is a reply to message #91290] Fri, 22 October 2004 01:12 Go to previous messageGo to next message
Lorets
Messages: 1
Registered: October 2004
Junior Member
How to put/setup classes123.zip in classpath?
Re: ClassNotFoundException(oracle.jdbc.driver.OracleDriver) [message #92802 is a reply to message #91290] Sun, 30 January 2005 21:01 Go to previous message
pramodmb
Messages: 2
Registered: December 2004
Junior Member
This might work if we use JDBC thin driver.. which i haven't tried.. but if we use JDBC OCI Driver.. just add classes12.zip in the classpath and add the follwoing entry in the java file
Connection con = DriverManager.getConnection("jdbc.odbc.oci8:@databasename","userid","pwd"); This will surely work.
Regards,
Pramod
Previous Topic: serializing an object
Next Topic: ORA-31011: XML parsing failed
Goto Forum:
  


Current Time: Sat Apr 20 00:59:23 CDT 2024