callablestatement inserting record but returning false

Class.forName(driver);
 connection = DriverManager.getConnection(dbname,user,pw);
 statement = connection.prepareCall("{call addStudent(?,?,?)}");
 }
 catch(ClassNotFoundException c20) {
 c20.printStackTrace();
 }
 catch(SQLException s23) {
 s23.printStackTrace();
 }
 }
 protected void doPost(HttpServletRequest req27, HttpServletResponse res27) throws ServletException, IOException {
 try {
 out = res27.getWriter();
 res27.setContentType("text/html");
 String s29 = req27.getParameter("sid");
 int i30 = Integer.parseInt(s29);
 String s30 = req27.getParameter("fn");
 String s31 = req27.getParameter("ln");
 if(i30<0) {
 out.println("<HTML><HEAD><TITLE>Student id invalid</TITLE></HEAD><BODY>Invalid student id <a href=\"Student\">Go to home page</a></BODY></HTML>");
 }
 else {
 statement.setInt(1,i30);
 statement.setString(2,s30);
 statement.setString(3,s31);
 statement.executeUpdate();
 out.println("<HTML><HEAD><TITLE>Student information added successfully</TITLE></HEAD><BODY>Student information has been added successfully <a href=\"Student\">Go to home page</a> <a href=\"addStudent.jsp\">Create new student</a></BODY></HTML>");
 }
 }
 catch(NumberFormatException n35) {
 out.println("<HTML><HEAD><TITLE>Unable to add the entered data</TITLE></HEAD><BODY>Please check student id and other information. <a href=\"Student\">Go to home page</a></BODY></HTML>");
 }
 catch(SQLException s31) {
 out.println("<HTML><HEAD><TITLE>Unable to add the entered data</TITLE></HEAD><BODY>Please check student id and other information. <a href=\"Student\">Go to home page</a></BODY></HTML>");
 out.close();
 }

I am entering student information in an html/jsp form which is invoking the servlet. I find the records inserted into database. However, after executeUpdate(), control is going to catch block. When I tried placing execute()/executeUpdate() in if else block, , control is going to else block but the record is being inserted successfully. Why is the execute() not returning a successful value?

Yes .. This is the actual behavior

Check the Spec.

http://java.sun.com/javame/reference/apis/jsr169/java/sql/CallableStatement.html

Yes, Meetgaurav U R rite..

Michael,
Please read the API documentation and look for the execute method. That will explain it all to you.

http://java.sun.com/javase/6/docs/api/java/sql/CallableStatement.html :thumb:

After the statement is executed, it should naturally go to the very next statement. Instead it jumped even when there was no test condition.