Now, there are two replacement parameters in the query, denoted by 2 question marks. You need to set values for both of the replacement parameters
For example ps.setString(1, "John"); ps.setInt(2, 30);
If you miss to set the value for any of the replacement parameters, you get this exception. Check whether you have enough setXXX methods for the number of ? you have in the query.
Joined: Jul 26, 2001
It means you have a PreparedStatement or CallableStatement in which you've not set all the parameters. Recheck to see that all parameters have been set and if your calling a stored procedure check to see that the number of parameters in your call matches the procedure in the database.
Joined: Oct 12, 2000
more at home in the JDBC forum of course as it's a database specific problem.