Mapped Statements collection already contains value for

標籤：source   property   ibatis   cap   原因   select   arch   sel   sql   

解決了！ 參考的網址：http://www.cnblogs.com/langtianya/archive/2013/03/18/2966491.html

錯誤原因是由於使用ibatis的F554281Mapper.xml實現介面F554281Mapper.java中的方法的時候的id有重複的值，比如

 <select id="find81OrderBySovr01" resultMap="81ResultMap" parameterType="java.util.Map">中的find81OrderBySovr01在一個xml檔案中有兩個這樣的id，修改過來即可

select查詢中的parameterType 也可以是實體類 <select id="find81OrderBySovr01"  parameterType="com.chong.model.Account" resultType="int">

 

單詞：nested  /nestid/   潛逃的

nested

英[nest?d]

美[nest?d]

adj.

嵌套的;

v.	築巢( nest的過去式和過去分詞 );

 [例句]In the makeGrades method I use a code block nested inside of another code block.在makeGrades方法中，我使用了嵌套在一個代碼塊中的另一個代碼塊。

[其他]

原型： nest

報錯的報文：

nifiedOrderProject] 2017-01-10 17:17:00,334 [org.mybatis.spring.SqlSessionFactoryBean]-[DEBUG] Parsed mapper file: ‘file [D:\javaInstall\apache-tomcat-8.0.32-windows-x64\apache-tomcat-8.0.32\wtpwebapps\unifiedOrderProject\WEB-INF\classes\com\eaju\mapping\ReceiveMerchantOrder.xml]‘
[unifiedOrderProject] 2017-01-10 17:17:00,370 [org.mybatis.spring.SqlSessionFactoryBean]-[DEBUG] Parsed configuration file: ‘class path resource [mybatis-config.xml]‘
[unifiedOrderProject] 2017-01-10 17:17:00,401 [org.springframework.web.context.support.XmlWebApplicationContext]-[WARN] Exception encountered during context initialization - cancelling refresh attempt
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘unifiedOrderServiceImpl‘: Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘f554281Mapper‘ defined in file [D:\javaInstall\apache-tomcat-8.0.32-windows-x64\apache-tomcat-8.0.32\wtpwebapps\unifiedOrderProject\WEB-INF\classes\com\eaju\dao81\F554281Mapper.class]: Cannot resolve reference to bean ‘sqlSessionFactory81‘ while setting bean property ‘sqlSessionFactory‘; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘sqlSessionFactory81‘ defined in class path resource [spring-mybatis.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: ‘file [D:\javaInstall\apache-tomcat-8.0.32-windows-x64\apache-tomcat-8.0.32\wtpwebapps\unifiedOrderProject\WEB-INF\classes\com\eaju\mapping81\F554281Mapper.xml]‘; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.eaju.dao81.F554281Mapper.find81OrderBySovr01
 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:308)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1210)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
 at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:755)
 at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:757)
 at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:480)
 at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:403)
 at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:306)
 at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
 at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4812)
 at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5255)
 at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
 at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408)
 at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
 at java.lang.Thread.run(Thread.java:745)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘f554281Mapper‘ defined in file [D:\javaInstall\apache-tomcat-8.0.32-windows-x64\apache-tomcat-8.0.32\wtpwebapps\unifiedOrderProject\WEB-INF\classes\com\eaju\dao81\F554281Mapper.class]: Cannot resolve reference to bean ‘sqlSessionFactory81‘ while setting bean property ‘sqlSessionFactory‘; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘sqlSessionFactory81‘ defined in class path resource [spring-mybatis.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: ‘file [D:\javaInstall\apache-tomcat-8.0.32-windows-x64\apache-tomcat-8.0.32\wtpwebapps\unifiedOrderProject\WEB-INF\classes\com\eaju\mapping81\F554281Mapper.xml]‘; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.eaju.dao81.F554281Mapper.find81OrderBySovr01
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:359)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1477)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1222)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:537)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:461)
 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:435)
 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:559)
 at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:169)
 at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
 at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:305)
 ... 22 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘sqlSessionFactory81‘ defined in class path resource [spring-mybatis.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: ‘file [D:\javaInstall\apache-tomcat-8.0.32-windows-x64\apache-tomcat-8.0.32\wtpwebapps\unifiedOrderProject\WEB-INF\classes\com\eaju\mapping81\F554281Mapper.xml]‘; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.eaju.dao81.F554281Mapper.find81OrderBySovr01
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:539)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:476)
 at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:303)
 at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
 at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:299)
 at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
 at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
 ... 37 more
Caused by: org.springframework.core.NestedIOException: Failed to parse mapping resource: ‘file [D:\javaInstall\apache-tomcat-8.0.32-windows-x64\apache-tomcat-8.0.32\wtpwebapps\unifiedOrderProject\WEB-INF\classes\com\eaju\mapping81\F554281Mapper.xml]‘; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.eaju.dao81.F554281Mapper.find81OrderBySovr01
 at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:466)
 at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:340)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1633)
 at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1570)
 ... 44 more
Caused by: org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.eaju.dao81.F554281Mapper.find81OrderBySovr01
 at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:117)
 at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:89)
 at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:464)
 ... 47 more
Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.eaju.dao81.F554281Mapper.find81OrderBySovr01
 at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:776)
 at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:748)
 at org.apache.ibatis.session.Configuration.addMappedStatement(Configuration.java:578)
 at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:315)

 

Mapped Statements collection already contains value for