an error while inserting data in access database through jsp

**shubhraagarwal** · Aug 18 '10, 07:45 AM

index.html page:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dt d">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>User Registration form</title>
</head>

<body>

<form action="registr ation.jsp" method="post">
<table align="center" width="70%" border="0" cellspacing="2" cellpadding="2" >
<tr>
<td width="19%">Use r Name</td>
<td width="10%">:</td>
<td width="71%"><in put type="text" name="user_name " />
</td>
</tr>
<tr>
<td>User ID </td>
<td>:</td>
<td><input type="text" name="user_id" /></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input type="password" name="pswd"/></td>
</tr>
<tr>
<td>Mobile</td>
<td>:</td>
<td><input type="text" name="mobile" /></td>
</tr>
<tr>
<td>Email-id</td>
<td>:</td>
<td><input type="text" name="email_id" /></td>
</tr>
<tr>
<td>Address</td>
<td>:</td>
<td><input type="textarea" name="address" /></td>
</tr>
<tr>
<td>Date Of Birth </td>
<td>:</td>
<td><input type="text" name="dob" /></td>
</tr>
<tr>
<td>Marks in 10th</td>
<td>:</td>
<td><input type="text" name="marks10th " /></td>
</tr>
<tr>
<td>Marks in 12th</td>
<td>:</td>
<td><input type="text" name="marks12th " /></td>
</tr>
<tr>
<td>Marks in Graduation</td>
<td>:</td>
<td><input type="text" name="marksgrad uation" /></td>
</tr>
<tr>
<td>Marks in Post Graduation</td>
<td>:</td>
<td><input type="text" name="markspg" /></td>
</tr>
<tr>
<td>Other Certification</td>
<td>:</td>
<td><input type="text" name="othercert ification" /></td>
</tr>
<tr>
<td>Experienc e</td>
<td>:</td>
<td><input type="text" name="experienc e" /></td>
</tr><br/>
<tr >
<td></td>
<td ><br />
<input type="submit" value="Submit" /></td>
</tr>
</table>
</form>

</body>
</html>

registration.js p page:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" >

<html>
<body>

<%@page language="java" %>
<%@page import="java.sq l.*"%>
<%@page import="java.io .*"%>
<%@page import="java.ut il.*"%>

<%!

Connection con;
PreparedStateme nt pstmt;
//Statement stmt;
//ResultSet res;
String url,user_name,e mail,address,da te_of_birth,oth er_certificatio n,user_id,passw ord;
int marks_10,marks_ 12,marks_ug,mar ks_pg,experienc e;
int mobile;

%>

<%

DriverManager.r egisterDriver(n ew sun.jdbc.odbc.J dbcOdbcDriver() );
url = "jdbc:odbc:atte ndance";
con = DriverManager.g etConnection(ur l);

user_name = request.getPara meter("user_nam e");
email = request.getPara meter("email_id ");
address = request.getPara meter("address" );
date_of_birth = request.getPara meter("dob");
other_certifica tion = request.getPara meter("othercer tification");
user_id = request.getPara meter("user_id" );
password = request.getPara meter("pswd");
mobile = Integer.parseIn t(request.getPa rameter("mobile "));
marks_10 = Integer.parseIn t(request.getPa rameter("marks1 0th"));
marks_12 = Integer.parseIn t(request.getPa rameter("marks1 2th"));
marks_ug = Integer.parseIn t(request.getPa rameter("marksg raduation"));
marks_pg = Integer.parseIn t(request.getPa rameter("marksp g"));
experience = Integer.parseIn t(request.getPa rameter("experi ence"));
//stmt= con.createState ment();
//res = pstmt.executeQu ery("select id from registration");
//sid = Integer.parseIn t(res.getInt(id ));
pstmt = con.prepareStat ement("insert into registration(us er_name,mobile, email,address,d ate_of_birth,ma rks_10th,marks_ 12th,marks_ug,m arks_pg,other_c ertification,ex perience,user_i d,password) values(?,?,?,?, ?,?,?,?,?,?,?,? ,?)");

//res.setInt(1,si d);
pstmt.setString (1,user_name);
pstmt.setInt(2, mobile);
pstmt.setString (3,email);
pstmt.setString (4,address);
pstmt.setString (5,date_of_birt h);
pstmt.setInt(6, marks_10);
pstmt.setInt(7, marks_12);
pstmt.setInt(8, marks_ug);
pstmt.setInt(9, marks_pg);
pstmt.setString (10,other_certi fication);
pstmt.setInt(11 ,experience);
pstmt.setString (12,user_id);
pstmt.setString (13,password);
pstmt.executeUp date();
con.close();
%>

</body>
</html>

and the error is:

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasp er.JasperExcept ion: For input string: ""
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 358)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)

root cause

java.lang.Numbe rFormatExceptio n: For input string: ""
java.lang.Numbe rFormatExceptio n.forInputStrin g(Unknown Source)
java.lang.Integ er.parseInt(Unk nown Source)
java.lang.Integ er.parseInt(Unk nown Source)
org.apache.jsp. registration_js p._jspService(r egistration_jsp .java:69)
org.apache.jasp er.runtime.Http JspBase.service (HttpJspBase.ja va:133)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)
org.apache.jasp er.servlet.JspS ervletWrapper.s ervice(JspServl etWrapper.java: 311)
org.apache.jasp er.servlet.JspS ervlet.serviceJ spFile(JspServl et.java:301)
org.apache.jasp er.servlet.JspS ervlet.service( JspServlet.java :248)
javax.servlet.h ttp.HttpServlet .service(HttpSe rvlet.java:856)

note The full stack trace of the root cause is available in the Tomcat logs.

--------------------------------------------------------------------------------

Apache Tomcat/5.0.16