COUNT field incorrect or syntax error

Hi,

when I run my servlet, I am getting the error " java.sql.SQLException: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax error". My servlet, database table code and all the necessary things are below.

Form.html

SaveData.java

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.sql.*;

public class SaveData extends HttpServlet
{
 private Connection con;
 private int i;
 private PreparedStatement ps;
 private PrintWriter pw;
 
 public void init()
 {
 i = 0;
 }
 
 public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
 {
 pw = response.getWriter();
 
 
 try
 {
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 con = DriverManager.getConnection("jdbc:odbc:Employee2","sa","sasasa");
 ps = con.prepareStatement("insert into Emp_Data values(?,?,?,?,?,?)");
 
 ps.setString(1, request.getParameter("firstName"));
 ps.setString(2, request.getParameter("lastName"));
 ps.setString(3, request.getParameter("address"));
 ps.setString(4, request.getParameter("department"));
 // ps.setInt(5, Integer.parseInt(request.getParameter("age")));
 ps.setString(6, request.getParameter("designation"));
 
 i = ps.executeUpdate();
 
 if(i>0)
 {
 response.setContentType("text/html");
 
 pw.println("Data has been inserted succesfully ");
 }
 }
 catch(Exception e)
 {
 pw.println("An Error Occuered: "+e);
 e.printStackTrace();
 }
 }
 
 
 public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException
 {
 pw = response.getWriter();
 
 try
 {
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 con = DriverManager.getConnection("jdbc:odbc:Employee2","sa","sasasa");
 ps = con.prepareStatement("insert into Emp_Data values(?,?,?,?,?,?)");
 
 ps.setString(1, request.getParameter("firstName"));
 ps.setString(2, request.getParameter("lastName"));
 ps.setString(3, request.getParameter("address"));
 ps.setString(4, request.getParameter("department"));
 // ps.setInt(5, Integer.parseInt(request.getParameter("age")));
 ps.setString(6, request.getParameter("designation"));
 
 i = ps.executeUpdate();
 
 if(i>0)
 {
 response.setContentType("text/html");
 
 pw.println("Data has been inserted succesfully ");
 }
 }
 catch(Exception e)
 {
 pw.println("An Error Occuered: "+e);
 }
 }
 
}

My database table is below

Following is my web.xml file

In my SaveData.java file, is I remove the comment symbol "//" it passes " Number Format Exception". When I put the comment line and run, it passes the previous error, which is bothering me (I guess NumberFormat Error also a part of it, at least I have seen that before but the NEW error is DANGEROUS!). Please help me. Thanks

Apart from that I am using the same DATABASE under the SAME DSN in my NON SERVLET java applications. All are working fine without any error. I just checked this with my desktop and laptop with NetBeans and Manually, but no good

Moved to the JDBC forum.

Hi,
Can you show here full stack trace error so it will easy to detect the error.

Bear Bibeault wrote:Moved to the JDBC forum.

Thanks for moving this thread Bear Bibeault

. I really appreciate that.

Miku Ranjan wrote:Hi,
Can you show here full stack trace error so it will easy to detect the error.

Hi Miku,

Thanks a lot for trying to help me out, and I really appreciate it. Anyway my lecturer solved that out today. Here are the reasons for the error.

For the NumberFormat Exception error which comes out without any reasonable reason, the answer is, USE TRIM() METHOD WHEN YOU ARE CONVERTING THAT TO NUMERIC. Seems like it has lot of junk spaces, LOL.

For the SQL Exception error, the answer is, use SYSTEM DSN CONFIGURATION. DO NOT CREATE A NEW DSN, CONFIGURE THE SYSTEM DSN "SQL".

Thanks all of you for trying to help me out.