8 Mar
2010
8 Mar
'10
4:02 p.m.
On 04-03-2010 12:43:17 -0800, sateesh wrote:
Yes we have set the Auto Commit to true.
Also we are not sure how many Queries we can execute as part of the Batch. We are trying to execute the Batch after 1000 Queries and then clear the batch and process the rest till we have none left.
Doing an execute/clear after each 1000 queries sounds healthy to me. If you have auto-commit turned on, you should see that from your batch all queries have been executed, even if previous ones did result in failure. You always get the feedback from the batch to track down which queries actually resulted in a failure. Do you have proofs that queries are not executed after one fails?