Prepared Statement - Dynamic Query - Batch Update
843854Mar 4 2005 — edited Mar 7 2005I am trying to update some 10 rows using batchUpdate. I encounted a problem like if 10 rows are supposed to be update, only the last row is updating.
1. Query - Dynamic Update query ( if the field is chanced only, we have to append the field in the query for updation)
2. Prepared Statment
3. Batch Execution - using addBatch(), executeBatch() methods.
If it is not dynamic query ( static query) using prepared statement , batch updation is happening without any problem.
Kindly provide me the work around.