when i deployed the following servlet program in tomcat i get the following errors description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Error instantiating servlet class InsertServlet org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859) org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588) org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489) java.lang.Thread.run(Unknown Source Here is the servlet code: import java.io.*; import java.lang.*; import java.sql.*; import javax.servlet.*; import javax.servlet.http.*;
public abstract class InsertServlet extends HttpServlet{ public void doPost(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOException { res.setContentType("text/html"); int count=0; PrintWriter out= res.getWriter(); String FirstName=req.getParameter("FirstName"); String LastName=req.getParameter("LastName"); String Email=req.getParameter("Email"); String Password=req.getParameter("Password"); String ConformPassword=req.getParameter("ConformPassword"); String Dateofbirth=req.getParameter("Dateofbirth"); int Age=Integer.parseInt(req.getParameter("Age")); String Gender=req.getParameter("Gender"); String Address=req.getParameter("Address"); String Country=req.getParameter("Country"); String State=req.getParameter("State"); String City=req.getParameter("City"); int Telephone=Integer.parseInt(req.getParameter("Telephone")); int Mobile=Integer.parseInt(req.getParameter("Mobile")); String Howdidyouhear=req.getParameter("Howdidyouhear"); PreparedStatement pstm=null;
try{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver ");
String ConnectionUrl = ("jdbc:sqlserver://localhost:1433;database=sree;integratedSecurity=true");
Connection con= DriverManager.getConnection(ConnectionUrl, "PRATAP", " ");
pstm=con.prepareStatement("insert into stureg(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
pstm.setString(1,FirstName);
pstm.setString(2,LastName);
pstm.setString(3,Email);
pstm.setString(4,Password);
pstm.setString(5,ConformPassword);
pstm.setString(6,Dateofbirth);
pstm.setInt(7,Age);
pstm.setString(8,Gender);
pstm.setString(9,Address);
pstm.setString(10,Country);
pstm.setString(11,State);
pstm.setString(12,City);
pstm.setInt(13,Telephone);
pstm.setInt(14,Mobile);
pstm.setString(15,Howdidyouhear);
int i = pstm.executeUpdate();
String sql = "select * from stureg";
PreparedStatement prest = con.prepareStatement(sql);
ResultSet rs = prest.executeQuery();
while(rs.next())
{
out.println(rs.getString(1) +"FirstName");
out.println(rs.getString(2) +"LastName");
out.println(rs.getString(3) +"Email");
out.println(rs.getString(4) +"Password");
out.println(rs.getString(5) +"ConformPassword");
out.println(rs.getString(6) +"Dateofbirth");
out.println(rs.getInt(7) +"Age");
out.println(rs.getString(8) +"Gender");
out.println(rs.getString(9) +"Address");
out.println(rs.getString(10) +"Country");
out.println(rs.getString(11) +"State");
out.println(rs.getString(12) +"City");
out.println(rs.getInt(13) +"Telephone");
out.println(rs.getInt(14) +"Mobile");
out.println(rs.getInt(15) +"Howdidyouhear");
if(i!=0)
{
System.out.print("
Record has been inserted");
}
else
{
System.out.print("failed to insert the data");
}
}
} catch(Exception e){ out.println(e); } } }