org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.Persiste

最新推荐文章于 2024-08-29 16:56:56 发布

鱼雨羽

最新推荐文章于 2024-08-29 16:56:56 发布

阅读量475

点赞数

文章标签： mybatis spring apache

本文链接：https://blog.csdn.net/qq_31897241/article/details/129560515

版权

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.UnsupportedOperationException
### The error may exist in file [E:\IdeaProject\demo1\Api-module\target\classes\mapper\TeacherMapper.xml]
### The error may involve demo.mapperInterface.TeacherMapper.SelectTeacherByOrgId
### The error occurred while handling results

解决方法：
吧resultType="list"换成resultType="map"即可
因为resultType是一行的结果，每行结果是个map，其他不变，该是list是list

  <select id="SelectTeacherByOrgId"  resultType="map" parameterType="map">
  SELECT org.orgID,orgName,teacherID,teacherName,teacherSubject,orgStation
  FROM org LEFT JOIN teacher on org.orgID=teacher.orgID WHERE org.orgID= #{orgid,jdbcType=INTEGER}
  </select>