 Transactions can either be controlled using SQL or API calls.It is recommended to use API calls for enabling and disabling the auto commit mode and for committing and rolling back transactions.Examples here.