Autocommit command The Autocommit command turns the connection's auto-commit mode on or off. Autocommit command Auto-committurning off

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.

Syntax AUTOCOMMIT { ON | OFF } Example ij> autocommit off; ij> DROP TABLE menu; 0 rows inserted/updated/deleted ij> CREATE TABLE menu (course CHAR(10), item CHAR(20), price INT); 0 rows inserted/updated/deleted ij> INSERT INTO menu VALUES ('entree', 'lamb chop', 14), ('dessert', 'creme brulee', 6), ('appetizer', 'baby greens', 7); 3 rows inserted/updated/deleted ij> commit; ij> autocommit on; ij>