When auto-commit is turned off, your DML is always embedded in a transaction, without a commit or a rollback. Then, make it clear that there is an open transaction, and provide a commit and a rollback button. Many other tools provide this important feature