Update resturns zero rows updated without throwing errors.
Joined: Dec 15, 2004
In one of our application code, we are performing executeUpdate on a prepared statement object. This is done in a loop on a large number of records, say 20000. On some occasions, the update fails to update the table with relevant information and returns without throwing any errors.
We need to know the reason why it is not updating the table even though the query is right?
Also, under what conditions does the update return zero rows ?
Steps taken :
1. Create and populate the preapred statement with values.
2. Lock the particular row for update.
3. executeUpdate on this prepared statement object.
The where clause is right and ... Still it fails consistently.
Well then something is wrong, so post your code (like Shailesh suggested) so that we can debug it for you.
By the way, I am currently looking for new employment -- since my current position is only temporary. Perhaps if I solve your problem for you, your employer would consider employing me (instead of you)? Just kidding