Implement AUTOCOMMIT

[apstndb]

AUTOCOMMIT
A boolean indicating whether or not the connection is in autocommit mode. The default is true.

SHOW VARIABLE AUTOCOMMIT
SET AUTOCOMMIT = { true | false }

You can change the value of this property only when there is no active transaction.

When AUTOCOMMIT is set to false, a new transaction is initiated automatically after you execute COMMIT or ROLLBACK. The first statement that you execute starts the transaction.