Hi all! I am trying to connect to JDBC in a servlet, the html page gets displayed the try statement and i find that the connection is not made. I am using tomact 4.0.4 and have deployed the class file in \webapps\ROOT\WEB-INF\classes directory. Can anyone please suggest a path forward? In case i need to map the servlet in web.xml, i don't know how to ! Thanks in advance! Khozaima my code: public class Servlet_JDBC extends HttpServlet{ Connection conn; private ServletConfig config; public void init(ServletConfig config) throws ServletException{ this.config=config; } public void service (HttpServletRequest req, HttpServletResponse res) throws ServletException, IOException { HttpSession session = req.getSession(true); res.setContentType("text/html"); PrintWriter out = res.getWriter(); out.println("<HTML><HEAD><TITLE>Query Results</TITLE>"); out.println("</HEAD>"); out.println("<BODY bgColor=blanchedalmond text=#008000 topMargin=0>"); out.println("<P align=center><FONT face=Helvetica><FONT color=fuchsia style=\"BACKGROUND COLOR :white\"><BIG><BIG>List</BIG></BIG></FONT></P>"); out.println("<P align=center>"); out.println("<TABLE align=center border=1 cellPadding=1 cellSpacing=1 width=\"75%\">");
out.println("<TR>"); out.println("<TD>PARAMETER</TD>"); out.println("<TD>VALUE</TD>"); out.println("</TR>"); try{ Class.forName("org.gjt.mm.mysql.Driver"); conn = DriverManager.getConnection("jdbc:mysql://databaseURL/dataBaseName", "userName", "password"); Statement stmt=conn.createStatement(); ResultSet rs=stmt.executeQuery("SELECT PARAMETER, VALUE FROM MYTABLE"); while(rs.next()){ out.println("<TR>"); out.println("<TD>" + rs.getString(1) + "</TD>"); out.println("<TD>" + rs.getString(2) + "</TD>"); out.println("</TR>"); } rs.close();stmt.close();conn.close(); }catch(Exception e){out.println(e.getMessage());} out.println("</TABLE></P>"); out.println("<P> </P></FONT></BODY></HTML>"); } public void destroy(){} } _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>