add possibility to set the auto-commit mode for a connection