turned off autocommit to enable testing