In this example method that I have, do I want to do a commitTransaction everytime after I do a executeBatch...or at the end of my batch process.
So if I have 1000 records and I execute a batch of them every 100 records. Do I go to 100 then executeBatch and commitTransaction, then go to the next 100 and executeBatch and commitTransaction? Or do I executeBatch for every 100 records and then commitTransaction? The reason I ask is that I am running a batch process that inserts 100,000 or so records and my WebLogic instance keeps crashing with OutOfMemory (even better that a rollback cannot occur so half of my transaction commits). I don't have this issue running regular SQL, so I am trying to discover what I am doing wrong to cause this performance hit. Thanks, -jay blanton -- View this message in context: http://www.nabble.com/executeBatch-not-returning-int-of-records-updated.-t1819686.html#a4978497 Sent from the iBATIS - User - Java forum at Nabble.com.
