ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From DavidR <david.rosenst...@corp.idt.net>
Subject RE: batch insert autocommit setting
Date Tue, 15 Aug 2006 11:12:24 GMT

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:david.rosenstark@corp.idt.net] 
> Sent: Tuesday, August 15, 2006 3:33 PM
> To: user-java@ibatis.apache.org
> 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.


Mime
View raw message