This exception happend to me when i was mistakenly assigning another query to my prepared statement.
I was setting all the parametes to my string query and the trying to run the execute method on my prepared statement passing it the sql string again ,what was happening behind the scene that I was unpreparing my statement and losing all the parameters and passing a qury with "?" in it :) so below is teh solution
Instead of:
I was setting all the parametes to my string query and the trying to run the execute method on my prepared statement passing it the sql string again ,what was happening behind the scene that I was unpreparing my statement and losing all the parameters and passing a qury with "?" in it :) so below is teh solution
Instead of:
rs = ps.executeQuery(Query);
you should execute:rs = ps.executeQuery();
No comments:
Post a Comment