commit transaction before returning update id