problem with batchupdate
843854Aug 1 2003 — edited Aug 6 2003Hi All,
I am trying to to batch update with CallableStatement.
First I set autocommit off.
Then in the while loop and add the batch statement to my CallableStatement
after the loop I call executeBatch on CallableStatement which returns an array of int.
At the end I do a commit.
Eventhough I am adding multiple records for batch update,the value of the array of int is only 1 which means only 1 record is updated. I verified in the database that,it is updating only one record no matter how many records I set for batch update.
Did anyone run into same issue?
Thanks