support for long and autocommit transactions