implemented autocommit at the end of sql transaction