I can't explain this, but I can note that configuration parameter autocommit is used when you don't use manual transaction management (you just do calls and don't use startTransaction method).
I also did a lot of tests and I think that there is something wrong in your code or configurations. Best, Aram -----Original Message----- From: DavidR [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 3:33 PM To: [email protected] Subject: batch insert autocommit setting I am experimenting with batch inserts. I followed the instructions Clinton posted here and made sure to have a startTransaction before the startBatch. I noticed one strange issue. When i set my datasource(DBCP thru Spring) to autocommit true, the pace is over 100 a second, while when autocommit is false, it is about 30 per second. the transactionmanager is set in sqlconfig is JDBC. What is the explanation for this? Also, if i start a transaction and throw an exception, shouldnt the inserts still get rolled back even when autocommit is true? Thanks, David -- View this message in context: http://www.nabble.com/batch-insert-autocommit-setting-tf2108481.html#a5811907 Sent from the iBATIS - User - Java forum at Nabble.com.
