db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Barnet Wagman <b.wag...@comcast.net>
Subject Autocommit and multi row INSERT
Date Thu, 16 Dec 2004 17:12:20 GMT
With automcommit == true, is an INSERT always treated as single 
transaction, even if the INSERT inserts multiple rows of data?  I've 
always assumed that this would be the case, but I'm not sure I've seen 
that in it the jdbc autocommit contract.  The practical question is 
whether I should turm autocommit off before issuing a multi-row insert.

I can test this in a benchmark, but if anyone actually knows, that would 
be better.

Thanks

Mime
View raw message