set prepare database code to autocommit