Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

java.lang.NoClassDefFoundError: oracle/jdbc/OracleDriver

843854Jan 19 2005 — edited Feb 4 2005
I am trying to connect from a servlet running in Tomcat on my desktop to an instance of Personal Oracle9i running on my desktop. I am gettiung NoClassDefFoundError. The code compiles.

I know it is a path issue but I am at a loss to figure out where. Tomcat does not find the driver however it is in my machines path.

Running following:
j2sdk1.4.1_02
Personal Oracle 9.2
Tomcat 4.1.29
Windows XP

I have added the location of Classes12.zip to the class path: .;c:\Sun\AppServer\lib\j2ee.jar;c:\Sun\AppServer\lib\j2ee-svc.jar;d:\oracle\ora92\jdbc\lib\classes12.zip;

The "root cause" of error is:

java.lang.NoClassDefFoundError: oracle/jdbc/OracleDriver
at OOP.OracleConnectionDemo.doPost(OracleConnectionDemo.java:34)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)

The code is as follows:
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import oracle.jdbc.OracleDriver;
//import oracle.jdbc.driver.*; //did not work either

public class OracleConnectionDemo extends HttpServlet {

public void doPost(HttpServletRequest req, HttpServletResponse resp)
throws ServletException, IOException{

Connection con = null;


// Load the Oracle JDBC driver
try{
//two versions did not work
//DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver);
DriverManager.registerDriver(new OracleDriver());
con = DriverManager.getConnection
("jdbc:oracle:thin:@micron.1521:MCAP","scott","scott");

}
catch (SQLException e){

}
catch (Exception e){

}
finally{
try{
if (con != null)
con.close();
}
catch(SQLException ignored){
}

}//finally

}
}
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2005
Added on Jan 19 2005
4 comments
1,147 views