Thread: I am trying to show database contents in the browser through servlets

I have this servlet code for retrieving contents from database and displaying it on the browser.But when I am running this code it is giving "ClassNotFound Exception" at Class.forname().I have built the path with db2jcc.jar and db2jcc_license.jar file but still this exception is thrown.I also tried to do it with JSP but over there also same exception was thrownPlease help me

 
 
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 java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.*;
 
 
 
/**
 * Servlet implementation class HelloServlet
 */
public class HelloServlet extends HttpServlet {
 
	public Statement statement;
	public Connection connection;
 
 
	private static final long serialVersionUID = 1L;
 
 
    /**
     * @see HttpServlet#HttpServlet()
     */
    public HelloServlet() {
        super();
        // TODO Auto-generated constructor stub
    }
 
 
 
	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
 
    protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
 
 
	PrintWriter out=response.getWriter();
	out.print("dkfjdkfjdkjfd");
 
	     // Statement statement = null;
 
	      ResultSet rs = null;
	    System.out.println("loading class") ;
 
	      try {
			Class.forName("com.ibm.db2.jcc.DB2Driver");//Exception thrown
			System.out.println("abcd");
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
 
	System.out.println("after loading class"); 
 
	      try {
			connection  = DriverManager.getConnection("jdbc:db2://localhost:50000/Simple","administrator","welcome2sa2");                                                                         // Exception thown
		System.out.println(connection.getClass());
	      } catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	  System.out.println("after conncetion class");
	     try {
		 statement = connection.createStatement();                                //Exception thrown
		 System.out.print("abcd");
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
 
 
 
	      String QueryString = "select * from question";
 
	      try {
			rs = statement.executeQuery(QueryString);
			while(rs.next()){
				for(int i=1;i<=6;++i)
					out.print(rs.getString(i)+"\t");
 
			}
					} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		// TODO Auto-generated method stub
	}
 
 
}

Originally Posted by copeg

It helps to post the full exception...that being said, if it cannot find the class then the class is not on the classpath - make sure the driver is on the of your webapp.

Thanks for help.That problem is solved now.Now I am having some logical errors which I am trying to solve.If you could help me with those errors it will be great.I have posted my query in this forum only with title "I have a prob in my JSP code".you can search for this title with my name and can get what the errors are about.Thanks once again