mybatis配置mapper-locations的坑

很多時(shí)候想把xml文件與mapper類放在一起。

mapper-locations: com.demo.dao.*.xml

這么配置之后 發(fā)現(xiàn)報(bào)錯(cuò)找不到xml中id

pom.xml配置這句話就可以了??！

<build>
? ? <resources>
? ? ? ? <resource>
? ? ? ? ? ? <directory>src/main/java</directory>
? ? ? ? ? ? <includes>
? ? ? ? ? ? ? ? <include>**/*.xml</include>
? ? ? ? ? ? </includes>
? ? ? ? ? ? <filtering>true</filtering>
? ? ? ? </resource>
? ? </resources>
</build>

mapperLocations配置失效

xml文件的目錄結(jié)構(gòu)：分oracle數(shù)據(jù)庫(kù)的mapper.xml文件夾和瀚高數(shù)據(jù)庫(kù)的mapper.xml文件夾

mybatis配置: 加載瀚高的xml文件

啟動(dòng)項(xiàng)目報(bào)錯(cuò)信息：

09:00:26.392 [main] ERROR o.s.b.SpringApplication - [reportFailure,837] - Application run failed
org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'MPUserInfoDao' defined in file [D:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\com\jiahe\datasource\dao\signatureapp\MPUserInfoDao.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 [com/baomidou/mybatisplus/autoconfigure/MybatisPlusAutoConfiguration.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:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\mapper\oracle\admin\CaDlrqzDao.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [D:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\mapper\oracle\admin\CaDlrqzDao.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.jiahe.datasource.dao.signaturepc.CaDlrqzDao.caQyqzResult
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1524)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1404)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:593)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:878)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:879)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551)
    at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:143)
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758)
    at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750)
    at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405)
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:315)
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237)
    at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226)
    at com.jiahe.datasource.JiaheYlqDatasourceApplication.main(JiaheYlqDatasourceApplication.java:20)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [com/baomidou/mybatisplus/autoconfigure/MybatisPlusAutoConfiguration.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:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\mapper\oracle\admin\CaDlrqzDao.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [D:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\mapper\oracle\admin\CaDlrqzDao.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.jiahe.datasource.dao.signaturepc.CaDlrqzDao.caQyqzResult
    at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:657)
    at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:637)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1336)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1176)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:556)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516)
    at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
    at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1307)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1227)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1509)
    ... 18 common frames omitted
Caused by: 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:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\mapper\oracle\admin\CaDlrqzDao.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [D:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\mapper\oracle\admin\CaDlrqzDao.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.jiahe.datasource.dao.signaturepc.CaDlrqzDao.caQyqzResult
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:185)
    at org.springframework.beans.factory.support.ConstructorResolver.instantiate(ConstructorResolver.java:652)
    ... 31 common frames omitted
Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: 'file [D:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\mapper\oracle\admin\CaDlrqzDao.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [D:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\mapper\oracle\admin\CaDlrqzDao.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.jiahe.datasource.dao.signaturepc.CaDlrqzDao.caQyqzResult
    at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.buildSqlSessionFactory(MybatisSqlSessionFactoryBean.java:594)
    at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.afterPropertiesSet(MybatisSqlSessionFactoryBean.java:433)
    at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.getObject(MybatisSqlSessionFactoryBean.java:627)
    at com.baomidou.mybatisplus.autoconfigure.MybatisPlusAutoConfiguration.sqlSessionFactory(MybatisPlusAutoConfiguration.java:197)
    at com.baomidou.mybatisplus.autoconfigure.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$71f733e0.CGLIB$sqlSessionFactory$2(<generated>)
    at com.baomidou.mybatisplus.autoconfigure.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$71f733e0$$FastClassBySpringCGLIB$$7bf95d7a.invoke(<generated>)
    at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:244)
    at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:331)
    at com.baomidou.mybatisplus.autoconfigure.MybatisPlusAutoConfiguration$$EnhancerBySpringCGLIB$$71f733e0.sqlSessionFactory(<generated>)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:154)
    ... 32 common frames omitted
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'file [D:\idea-project\jiahe\yunlianqian\Jiahe-SignatureCloud\jiahe-modules\jiahe-ylq-datasource\target\classes\mapper\oracle\admin\CaDlrqzDao.xml]'. Cause: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.jiahe.datasource.dao.signaturepc.CaDlrqzDao.caQyqzResult
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:123)
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:95)
    at com.baomidou.mybatisplus.extension.spring.MybatisSqlSessionFactoryBean.buildSqlSessionFactory(MybatisSqlSessionFactoryBean.java:592)
    ... 45 common frames omitted
Caused by: java.lang.IllegalArgumentException: Result Maps collection already contains value for com.jiahe.datasource.dao.signaturepc.CaDlrqzDao.caQyqzResult
    at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:992)
    at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:948)
    at org.apache.ibatis.session.Configuration.addResultMap(Configuration.java:704)
    at org.apache.ibatis.builder.MapperBuilderAssistant.addResultMap(MapperBuilderAssistant.java:209)
    at org.apache.ibatis.builder.ResultMapResolver.resolve(ResultMapResolver.java:47)
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:289)
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElement(XMLMapperBuilder.java:254)
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.resultMapElements(XMLMapperBuilder.java:246)
    at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:119)
    ... 47 common frames omitted

我配置加載的是highgo文件夾下的xml文件，但他卻還是加載oracle文件夾下的xml文件。

問題根源

項(xiàng)目的配置文件里面mybatis和mybatis-plus都配置了，而mybatis-plus的配置信息優(yōu)先級(jí)高于mybatis的配置，所以導(dǎo)致mybatis的配置無(wú)效。 

解決

使用mybatis-plus的配置，移除mybatis的配置。

以上為個(gè)人經(jīng)驗(yàn)，希望能給大家一個(gè)參考，也希望大家多多支持腳本之家。

最新評(píng)論