add sql commit and rollback interfaces