Switch to auto-commit for all the non-update transactions.