<select id="getPersonRecordId" parameterType="java.lang.String" resultType="int">

    select role_id

    from p_person_role

    where stffe_id = #{stffeId,jdbcType=VARCHAR}

  </select>

Servlet.service() for servlet [springDispatcherServlet] in context with path [/xxxx] threw exception [Request processing failed;

nested exception is org.apache.ibatis.binding.BindingException: Mapper method 'com.xxx.PersonRoleRelationMapper.getPersonRecordno attempted to return null from a method with a primitive return type (int).]

with root cause org.apache.ibatis.binding.BindingException: Mapper method 'com.xxx.PPersonRoleRelationMapper.getPersonRecordno attempted to return null from a method with a primitive return type (int).

select IFFULL(MAX(role_id),) AS role_id  from  p_person_role where  stffe_id = #{stffeId,jdbcType=VARCHAR}