I am having trouble with a prepared statement in my JavaServlet's data manager where it inserts a member into the database. I believe the syntax is correct, but I always seem to get the error:
The error is in line 41 of the code you posted. Review the API documentation for PreparedStatement. In particular the documentation for the executeUpdate method.
Yes,Paul Clapham is right. The method prepareStatement holds parameterized SQL statements that needs to be sent to the database. So while calling executeUpdate, no parameter is required.
Regards,
Deepakkumar Devarajan
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.