nested exception is java.sql.SQLIntegrityConstraintViolationException

nested exception is java.sql.SQLIntegrityConstraintViolationException: Column ‘user_id’ in field list is ambiguous

• message表和user表根据 user_id 进行联查,查找结果中包含message表的 user_id，
  原查询语句为

 <select id="getAllMessage" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />,`user`.user_name AS userName
    from message JOIN user on message.user_id = user.user_id
  </select>

因为直接用了，里面的 user_id指代不明报错
nested exception is java.sql.SQLIntegrityConstraintViolationException: Column ‘user_id’ in field list is ambiguous
解决方法：将替换为
message_id, message.user_id, message_content, message_time,user.user_name AS userName

  <select id="getAllMessage" resultMap="BaseResultMap">
    select
      message_id, message.user_id, message_content, message_time,user.user_name AS userName
    from message JOIN user on message.user_id = user.user_id
  </select>

问题解决，查询成功！