Home » Developer & Programmer » JDeveloper, Java & XML » ClassNotFoundException:oracle.jdbc.driver.OracleDriver
ClassNotFoundException:oracle.jdbc.driver.OracleDriver [message #90911] Tue, 04 December 2001 12:18 Go to next message
Moutts
Messages: 8
Registered: December 2001
Junior Member
hi,
Iam trying to connect to oracle database using thin driver. i set the path with classes12.zip and trying to test a small jdbc application to connect to the database. but im gettingCaught ClassNotFoundExceptionoracle.jdbc.driver.OracleDriver
Exception in thread "main" java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getConnection(DriverManager.java:537)
at java.sql.DriverManager.getConnection(DriverManager.java:177)
at TestJDBC.main(TestJDBC.java:20)
can anyone tell me what is the problem.

----------------------------------------------------------------------
Re: ClassNotFoundException:oracle.jdbc.driver.OracleDriver [message #90913 is a reply to message #90911] Tue, 04 December 2001 21:47 Go to previous messageGo to next message
eirik
Messages: 4
Registered: November 2001
Junior Member
The Java-application cannot access classes12.zip !

REASON:
classes12.zip is not CORRECTLY specified in the classpath
OR
the application is not using the classpath

I'm not in here very often, send a mail if you have problems...

Brgds,
Eirik Olimstad

----------------------------------------------------------------------
Re: ClassNotFoundException:oracle.jdbc.driver.OracleDriver [message #90998 is a reply to message #90911] Sat, 02 February 2002 22:58 Go to previous messageGo to next message
Fakhry
Messages: 2
Registered: February 2002
Junior Member
Could anyone help me find out what this error is

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver [[oracle.jdbc.driver.OracleDriver]]
at allaire.jrun.servlet.JRunServletLoader.loadClass(../servlet/JRunServletLoader.java:430)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at ConnectionPool.<init>(ConnectionPool.java:20)
at LoginInfoMain.init(LoginInfoMain.java:37)
at allaire.jrun.servlet.JRunServletLoader.loadServletInstance(../servlet/JRunServletLoader.java:203)
at allaire.jrun.servlet.JRunServletLoader.loadServletInstance(../servlet/JRunServletLoader.java:161)
at allaire.jrun.servlet.JRunServletLoader.loadServlet(../servlet/JRunServletLoader.java:149)
at allaire.jrun.servlet.JRunSE.getServletReference(../servlet/JRunSE.java:1706)
at allaire.jrun.servlet.JRunSE.getNamedDispatcher(../servlet/JRunSE.java:1963)
at allaire.jrun.servlet.Invoker.service(../servlet/Invoker.java:64)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1417)
at allaire.jrun.session.JRunSessionService.service(../session/JRunSessionService.java:1082)
at allaire.jrun.servlet.JRunSE.runServlet(../servlet/JRunSE.java:1271)
at allaire.jrun.servlet.JRunRequestDispatcher.forward(../servlet/JRunRequestDispatcher.java:89)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1553)
at allaire.jrun.servlet.JRunSE.service(../servlet/JRunSE.java:1543)
at allaire.jrun.servlet.JvmContext.dispatch(../servlet/JvmContext.java:364)
at allaire.jrun.jrpp.ProxyEndpoint.run(../jrpp/ProxyEndpoint.java:388)
at allaire.jrun.ThreadPool.run(../ThreadPool.java:272)
at allaire.jrun.WorkerThread.run(../WorkerThread.java:75)
Re: ClassNotFoundException:oracle.jdbc.driver.OracleDriver [message #91375 is a reply to message #90998] Wed, 31 July 2002 17:25 Go to previous messageGo to next message
sweety
Messages: 1
Registered: July 2002
Junior Member
Please help me

500 Internal Server Error
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at com.evermind[[Orion/1.5.2 (build 10460)]]._wj.findClass(Unknown Source)
at java.lang.Exception.<init>(Exception.java, Compiled Code)
at java.lang.ClassNotFoundException.<init>(ClassNotFoundException.java, Compiled Code)
at com.evermind[[Orion/1.5.2 (build 10460)]]._wj.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(ClassLoader.java, Compiled Code)
at java.lang.ClassLoader.loadClass(ClassLoader.java, Compiled Code)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java, Compiled Code)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:117)
at /cuba/2.jsp._jspService(/cuba/2.jsp.java, Compiled Code)
at com.orionserver[[Orion/1.5.2 (build 10460)]].http.OrionHttpJspPage.service(Unknown Source)
at com.evermind[[Orion/1.5.2 (build 10460)]]._ah._rad(Unknown Source)
at com.evermind[[Orion/1.5.2 (build 10460)]].server.http.JSPServlet.service(Unknown Source)
at com.evermind[[Orion/1.5.2 (build 10460)]]._cxb._abe(Unknown Source)
at com.evermind[[Orion/1.5.2 (build 10460)]]._cxb._uec(Unknown Source)
at com.evermind[[Orion/1.5.2 (build 10460)]]._io._twc(Unknown Source)
at com.evermind[[Orion/1.5.2 (build 10460)]]._io._gc(Unknown Source)
at com.evermind[[Orion/1.5.2 (build 10460)]]._if.run(Unknown Source)
Re: ClassNotFoundException:oracle.jdbc.driver.OracleDriver [message #92046 is a reply to message #91375] Tue, 17 February 2004 19:26 Go to previous messageGo to next message
vijaya
Messages: 10
Registered: May 2001
Junior Member
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run<urlclassloader.java:198>
Re: ClassNotFoundException:oracle.jdbc.driver.OracleDriver [message #92706 is a reply to message #92046] Thu, 09 December 2004 01:25 Go to previous message
Madhu
Messages: 36
Registered: April 2001
Member
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at QueryApp2.main(QueryApp2.java:25)

this is my program(i used TYPE2 driver)

import java.awt.event.*;
import java.awt.*;

public class QueryApp2 {

public static void main ( String [[ ]] args ) {

Connection c;

String name = "thornett";
String pass = "test";
String url = "jdbc:odbc:sample";
String query = "select * from DEPT";
String query_results = "";
int col;
int pos;

try {

System.out.println("connecting to the " + name + " data

source...");
Class.forName("oracle.jdbc.driver.OracleDriver");
c = DriverManager.getConnection("jdbc:odbc:oci9:madhu1", "scott",

"tiger");

Statement s = c.createStatement();

ResultSet rs = s.executeQuery ( query );


String v = ( c.getMetaData ( ) ).getDatabaseProductVersion();
System.out.println (v);

col = ( rs.getMetaData ( ) ).getColumnCount();
for(int i = 1;i<=col;i++)
{
String colname = ( rs.getMetaData ( ) ).getColumnName(i);
while (i == col)
{

System.out.println(colname + " ");
i++;
}
if(i<col)
System.out.print(colname + " ");

}

while (rs.next()) {
System.out.println(rs.getString(1) + " " +rs.getString(2) + " "

+rs.getString(3));







} // end while
System.out.println ( query_results);

} //end try

catch( Exception x ) {
x.printStackTrace();

}

} //end main

} //end QueryApp

i set the classpath and path
as classpath:d:oracleora90jdbclibclasses111.zip;
path:d:oracleora81bin;
Previous Topic: JDBC connection to oracle
Next Topic: jdbc driver make_c_state error!
Goto Forum:
  


Current Time: Fri Apr 26 18:28:22 CDT 2024