Updating a table in JSP

I want to update a table (Access database) in my JSP page, so I put the following code:

Code:

---

PreparedStatement stmt = connection.prepareStatement ("UPDATE employee SET name = 'XXX'");
stmt.setInt (1, 1);
stmt.setString (2, "XX");
stmt.setString (3, "XXX");
stmt.executeUpdate ();

---

but I get the following error:

Quote:

---

javax.servlet.ServletException: Index 1 is out of bounds

---

You should see the SQL data type field associated with the first variable in your PreparedStatement may be the inner query is lacking some fields. If this is not the case then may be due to the SQL type INTEGER, you should perhaps use setBigDecimal() or setShort() instead of setInt().

I modified the code:

Code:

---

PreparedStatement stmt = connection.prepareStatement ("UPDATE employee SET id =?, Name =?, FirstName =?");
stmt.setInt (1, 1);
stmt.setString (2, "xx");
stmt.setString (3, "xx");
stmt.executeUpdate ();

---

so I no longer get the error message, but it also does not update the database!

This problem occurs because of an error with the Development Kit JIT compiler. To fix this problem, disable the JIT compiler before starting the server. If an application is updated while it is running, WebSphere Application Server automatically stops the application or only its changed components, updates the application logic, and restarts the stopped application or its components. To minimize the occurrence of such errors, update applications in a test environment before updating the applications in a production environment.

Source: ibm.com