but i need to use startTransaction in order to do batch inserts, so i am a bit stuck here on this. Which configurations would you have in mind?
Mkhitaryan, Aram wrote: > > 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. > > > -- View this message in context: http://www.nabble.com/batch-insert-autocommit-setting-tf2108481.html#a5812319 Sent from the iBATIS - User - Java forum at Nabble.com.
