JDBC specifies that the default auto-commit mode is ON.
Certain types of processing require that auto-commit mode be
OFF. For information about auto-commit, see the
.
If auto-commit mode is changed from off to on when there is a transaction
outstanding, that work is committed when the current transaction commits, not at
the time auto-commit is turned on. Use
Commit or
Rollback before
turning on auto-commit when there is a transaction outstanding, so that all
prior work is completed before the return to auto-commit mode.