错误如下:
2020-05-11 08:55:21.333 WARN 937516 --- [ main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory
.UnsatisfiedDependencyException: Error creating bean with name 'demoController': Unsatisfied dependency expressed through field 'userServiceImpl'; nested exception is org.springframework.beans.factory
.BeanCreationException: Error creating bean with name 'userServiceImpl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating
bean with name 'userMapper' defined in file [D:\Code\QMSPull\demo\target\classes\com\multiple\demo\dao\UserMapper.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory'; nested exception is
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [org/mybatis/spring/boot/autoconfigure/MybatisAutoConfiguration.class]: Bean
instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [org.apache.ibatis.session.SqlSessionFactory]: Factory method 'sqlSessionFactory'
threw exception; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [D:\Code\QMSPull\demo\target\classes\mapper\UserMapper.xml]'; nested exception is org.apache.ibatis
.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [D:\Code\QMSPull\demo\target\classes\mapper\UserMapper.xml]'. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already
contains value for com.multiple.demo.dao.UserMapper.selectByPrimaryKey. please check file [D:\Code\QMSPull\demo\target\classes\mapper\UserMapper.xml] and file [D:\Code\QMSPull\demo\target\classes\mapper\UserMapper.xml]
然后我开始以下排查
- 检查各层注解
a. Collector层
b. Service层
c. SpringbootApplication是否开启包扫描或者dao层是否有@Mapper - 检查mapper.xml 中mapper标签指向的dao是否正确
mapper.xml中方法是否在Dao层声明过。
看到报错中有一条:
java.lang.IllegalArgumentException: Mapped Statements collection already
contains value for com.multiple.demo.dao.UserMapper.selectByPrimaryKey. please check file [D:\Code\QMSPull\demo\target\classes\mapper\UserMapper.xml] and file
后来我去查看UserMapper.xml (dao层对应mapper.xml文件)
两个sql ,id相同。
修改id即可