Servlet-JDBC

Hi everyone i'm using JSDK 2.0, JCreator and servletrunner as a server to run my servlet program and the program is getting compiled and .class file is also generated. I have copied that file into the examples folder of JSDK 2.0(That's the way i run servlet programs) and now am trying to run the program but it doesn't display "Record Is Saved" this message. Here is the code---

Client side code

Server side code

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;
public class registration extends HttpServlet
	{
		public void doGet(HttpServletRequest req, HttpServletResponse res)throws ServletException
		{
			PrintWriter pw = null;
			try{
				pw = res.getWriter();
				res.setContentType("text/html");
				int eno = Integer.parseInt(req.getParameter("eno"));
				String fname = req.getParameter("fname");
				String lname = req.getParameter("lname");
				String add = req.getParameter("add");
				String pcard = req.getParameter("pcard");
				int numb = Integer.parseInt(req.getParameter("numb"));
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				Connection cn = DriverManager.getConnection("jdbc: odbc:psoft","scott","tiger");
				PreparedStatement s = cn.prepareStatement("insert into psoft values(?,?,?,?,?,?)");
				s.setInt(1,eno);
				s.setString(2,fname);
				s.setString(3,lname);
				s.setString(4,add);
				s.setString(5,pcard);
				s.setInt(6,numb);
				s.executeUpdate();
				pw.println("Record Is Saved...!!!");
		}catch (Exception e){}
}
}

please help me!! Thanks!!!

Pranit Sonawane wrote:}catch (Exception e){}

Don't ever ignore exceptions like this. You probably get an exception that you're ignoring. Change that line into the following, and you'll see what goes wrong in your browser window:

Also, please UseCodeTags from now on.

Rob Spoor wrote:

Pranit Sonawane wrote:}catch (Exception e){}

Don't ever ignore exceptions like this. You probably get an exception that you're ignoring. Change that line into the following, and you'll see what goes wrong in your browser window:
}catch (Exception e){ throw new ServletException(e); }
Also, please UseCodeTags from now on.

gave me an error "Cannnot find symbol

Is there a reason you're using a version of servlets from 1998? Are you trying examples from an older book?

You might find there are a lot more difficulties in running such an old version of the Servlet environment, including a lot less support. At the same time, many modern IDEs (NetBeans, Eclipse, JDeveloper, etc) come with their own built-in Servlet container for testing. You should at least consider a more modern environment for learning Java & Servlets. You may get a lot more help.

Also, your previous post cuts the error message off at "Cannot find symbol". If we don't know what it's missing, it's hard to tell where your problem may be.

Unless ...

Is that space between "jdbc:" and "odbc" supposed to be there?