I think its only for that connection object on which the auto commit has been called. Because by default if we get a new connection its in auto commit mode.
In the sun specs its given as follows:
public void setAutoCommit(boolean autoCommit)
throws SQLExceptionSets this connection's auto-commit mode. 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 occurs, whichever comes first. In the case of statements returning a ResultSet, the statement completes 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.
Parameters:
autoCommit - true enables auto-commit; false disables auto-commit.
Throws:
SQLException - if a database access error occurs
Hope you have understood.
[changed code tag to quote so doesn't wrap page]
[ February 21, 2007: Message edited by: Jeanne Boyarsky ]
