reset auto-commit after transaction