Documentation / Commands / SET AUTOCOMMIT

SET AUTOCOMMIT

Core command SE AU

Turns autocommit ON or OFF

Arguments

ON/OFF or TRUE/FALSE

Examples

SET AUTOCOMMIT ON;

Notes

Toggles JDBC auto-commit for the current connection: SET AUTOCOMMIT ON|OFF (also accepts TRUE/FALSE as synonyms, case-insensitive).

The argument is mandatory - the command fails with an error if it is missing or not one of ON, OFF, TRUE, FALSE. The change is a live JDBC connection setting: it applies only to the current session and is not persisted across reconnects.

The console always reports the resulting state, and additionally warns that updates can no longer be rolled back whenever auto-commit ends up ON.

Last modified in release 5.0.7.