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.
