mybatis映射文件结果集resultMap错误:
先上错误:
Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException:
### Error building SqlSession.
### The error may exist in com/itqf/mapper/AuthorMapper.xml
### The error occurred while processing mapper_resultMap[authorMap]_collection[books]_collection[messages]
### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'com/itqf/mapper/AuthorMapper.xml'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.itqf.mapper.AuthorMapper.mapper_resultMap[authorMap]_collection[books]
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:80)
at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:64)
at com.itqf.test.UseMybatisSelect.main(UseMybatisSelect.java:29)
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'com/itqf/mapper/AuthorMapper.xml'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.itqf.mapper.AuthorMapper.mapper_resultMap[authorMap]_collection[books]
at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:121)
at org.apache.ibatis.builder.xml.XMLConfigBuilder.parse(XMLConfigBuilder.java:99)
at org.apache.ibatis.session.SqlSessionFactoryBuilder.build(SqlSessionFactoryBuilder.java:78)
... 2 more
作为一名后台开发者,我们的报错比起前端已经很友好了,因此我们一定要学会甄别出控制台打印的错误信息中哪一条是自己错误的根本所在,也就是错误的起源。
从报错信息Result Maps collection already contains中,我们应敏锐的反应出,这是多表查询使用resultMap时,定义id重复了。因为如果一旦你的mapper.xml文件中出现了相同的命名id,mybatis映射文件的时候是根据namespace+id,所以你的标签中出现了重复的id,程序区别不出哪一个才是你想要进行映射的,所以才会报出这句话:Result Maps collection already contain BaseResultMap。这是我的mapper.xml文件中定义 2个resultMap定义,之前两个resultMap的id都是authorMap,改正后就好了。
改动前:
<resultMap id="authorMap" type="author">
<resultMap id="authorMap" type="author">
改动后:
<resultMap id="authorMap" type="author">
<resultMap id="authorMapMessage" type="author">