Servlet jdbc problem

Hi guys... i have written a servlet program which performs a simple query from the datbase and displays the results.But my servlet is returning java.lang.NoClassDefFoundError: oracle/jdbc/driver/OracleDrive exception.
But if i perform the same database operation from a normal .java file i am getting the results.Please help

package controllers;
import java.sql.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import controllers.testd;
/**
 * Servlet implementation class SuccessServlet
 */
public class SuccessServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public SuccessServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}

/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html");
		PrintWriter out = response.getWriter();
		
		String url= "jdbc:oracle:thin://@127.0.0.1:1527:xe"; 
		String username= "system"; 
		String password= "tiger";
		String re="";
		try {
			java.sql.DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); 
			Class.forName("oracle.jdbc.driver.OracleDriver");
			Connection conn;
			conn = DriverManager.getConnection( url,username, password );
			Statement statement = conn.createStatement();
			ResultSet rs = statement.executeQuery("select * from hello" );
			while( rs.next() ){
				re=rs.getString("NAME");
			System.out.println(re);}
			rs.close();
			
			statement.close();
			conn.close();

}
		catch(Exception e){e.printStackTrace();}

out.println("<html>");
		out.println("<head>");
		out.println("<title> A very simple servlet example</title>");
		out.println("</head>");
		out.println("<body>");
		out.println("<h1>"+"welcome"+"</h1>");
		out.println("success in success");
		out.println("result is "+testd.re);
		
		out.println("</body>");
		out.println("</html>");
		out.close();
	}
	}

Where did you place the jar file with the drive class?

I have pasted my classes12.jar file in the webcontent/web-inf/lib directory.But my .java programs work fine.
Please help.....

The problem is that the folder must be named WEB-INF, not web-inf.

Sorry for not typing it correctly:
I have pasted in WebContent/WEB-INF/lib

Is that the WEB-INF (please read AvoidRedHerrings) for the web app in question?

And, are you using container-managed connection pooling? And, what container are you using?

Tomcat, for example, requires that the driver jar for connection-managed pooling be placed in the central Tomcat /lib folder.

I am using JBoss 4.0.2...
I dont know whether i have to place the jar file in the WebContent/WEB-INF/lib path or not.

Bear Bibeault wrote:And, are you using container-managed connection pooling?

Sorry i have no idea if it uses container-managed connection pooling.

Inspecting the code, it doesn't look like you are, so placing the jar/zip in WEB-INF/lib should be sufficient.

But there might be jBoss nuances that I don't know about, so I've moved this to the JBoss forum for the JBoss-savvy to have a gander at it.

P.S. You have already verified that the oracle.jdbc.driver.OracleDriver class is in the jar file, right?

I have pasted in WebContent/WEB-INF/lib

Are you working from an IDE? Are you experting the IDE to deploy your app? If so, did you double-check that the IDE did indeed copy the JDBC JAR file as part of the deployed application?

P.S. You should really use a connection pool and manage the database connection directly in your servlet.