Each statement will have its own commit.
To quote from the VA Java docs: " If a connection is in auto-commit
mode, then all its SQL
statements will be executed and committed as individual
transactions. Otherwise, its SQL
statements are grouped into transactions that are terminated by a
call to either the method
commit or the method rollback. By default, new connections are in
auto-commit mode. The
commit occurs when the statement completes or the next execute
comes first. In the case of statements returning a ResultSet, the
when the last row of the ResultSet has been retrieved or the
ResultSet has been closed. In
advanced cases, a single statement may return multiple results as
well as output
parameter values. In these cases the commit occurs when all results
and output parameter
values have been retrieved. "
On 28 Dec 2001 at 11:17, Joe Luthman wrote:
> We are using DBConnectionBroker with Java applications, in
> ensure connection pooling is being used.
> When we execute a Java command such as
> con.setAutoCommit( true )
> exactly when will the implied commit take place?And using what
> Is it really true that be using the setAutoCommit, I can avoid
> to explicitly invoke the commit method?
> Joe Luthman260 Hayes Hall
> DBAInformation Technology Services
> 419-372-7750Bowling Green State University
> Bowling Green, Ohio
> 43403 To change your
owners of the list can be reached at DB2-L-
> [login to unmask email]