ssm查询数据错误

最新推荐文章于 2023-05-01 14:23:07 发布

牛哞哞杂记

最新推荐文章于 2023-05-01 14:23:07 发布

阅读量393

点赞数

CC 4.0 BY-SA版权

分类专栏： spring 错误 ssm 文章标签： spring 错误

本文为博主原创文章，未经博主允许不得转载。

本文链接：https://blog.youkuaiyun.com/qq_40558766/article/details/88852922

spring 错误同时被 2 个专栏收录

8 篇文章

订阅专栏

ssm

8 篇文章

订阅专栏

本文记录了一次因MyBatis配置文件中存在重复ID导致的应用启动失败问题，并给出了相应的解决方案。错误出现在尝试加载两个相同的查询ID时，通过修改其中一个查询ID使其与Service层对应的方法名一致解决了该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

错误原因：mybatis配置文件里有两个查询的id一样。

解决方法：改成与service里对应的名字就ok啦
在这里插入图片描述

org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘userAction’: Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘com.tritonsfs.core.aspect’: Injection of resource dependencies failed; 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.BeanCreationException: Error creating bean with name ‘userDAO’ defined in file [D:\workspace\demo\userManager-app\bin\com\tritonsfs\user\dao\UserDAO.class]: Cannot resolve reference to bean ‘sqlSessionFactory’ while setting bean property ‘sqlSessionFactory’; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘sqlSessionFactory’ defined in file [D:\workspace\demo\userManager-app\bin\applicationContext-common.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: ‘file [D:\workspace\demo\userManager-app\bin\mapper\mapper-common-user.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.tritonsfs.user.dao.UserDAO.findByCondition
at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:321) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1348) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:578) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:501) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:760) ~[spring-beans-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:869) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759) ~[spring-boot-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395) ~[spring-boot-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at org.springframework.boot.SpringApplication.run(SpringApplication.java:327) ~[spring-boot-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at org.springframework.boot.test.context.SpringBootContextLoader.loadContext(SpringBootContextLoader.java:139) [spring-boot-test-2.0.2.RELEASE.jar:2.0.2.RELEASE]
at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:99) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:117) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:108) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.web.ServletTestExecutionListener.setUpRequestContextIfNecessary(ServletTestExecutionListener.java:190) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.web.ServletTestExecutionListener.prepareTestInstance(ServletTestExecutionListener.java:132) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:246) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:227) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:289) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.12.jar:4.12]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:291) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:246) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner $KaTeX parse error: Expected 'EOF', got '\workspace' at position 1736: …ned in file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ doGetBeanResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:618) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata $KaTeX parse error: Expected 'EOF', got '\workspace' at position 775: …ned in file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ doGetBeanResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:618) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata $KaTeX parse error: Expected 'EOF', got '\workspace' at position 606: …ned in file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ doGetBean $0 (A b s t r a c t B e a n F a c t o r y . j a v a : 317) [s p r i n g - b e a n s - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . D e f a u l t S i n g l e t o n B e a n R e g i s t r y . g e t S i n g l e t o n (D e f a u l t S i n g l e t o n B e a n R e g i s t r y . j a v a : 228) [s p r i n g - b e a n s - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . d o G e t B e a n (A b s t r a c t B e a n F a c t o r y . j a v a : 315) [s p r i n g - b e a n s - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . g e t B e a n (A b s t r a c t B e a n F a c t o r y . j a v a : 204) [s p r i n g - b e a n s - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . a n n o t a t i o n . C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r . a u t o w i r e R e s o u r c e (C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r . j a v a : 513) [s p r i n g - c o n t e x t - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . a n n o t a t i o n . C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r . g e t R e s o u r c e (C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r . j a v a : 484) [s p r i n g - c o n t e x t - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . a n n o t a t i o n . C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r$ ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:618) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata $KaTeX parse error: Expected 'EOF', got '\workspace' at position 616: …ned in file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ doGetBean $KaTeX parse error: Expected 'EOF', got '\workspace' at position 872: …urce: 'file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ StrictMap.put(Configuration.java:872) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:844) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.session.Configuration.addMappedStatement(Configuration.java:668) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:302) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:109) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:135) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:128) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:118) ~[mybatis-3.4.5.jar:3.4.5]
… 100 common frames omitted

2019-03-27 18:24:37.714 ERROR 14300 — [ main] o.s.test.context.TestContextManager : Caught exception while allowing TestExecutionListener [org.springframework.test.context.web.ServletTestExecutionListener@74e52303] to prepare test instance [com.tritonsfs.user.service.UserServiceTest@bd1111a]

java.lang.IllegalStateException: Failed to load ApplicationContext
at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:125) ~[spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:108) ~[spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.web.ServletTestExecutionListener.setUpRequestContextIfNecessary(ServletTestExecutionListener.java:190) ~[spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.web.ServletTestExecutionListener.prepareTestInstance(ServletTestExecutionListener.java:132) ~[spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:246) ~[spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:227) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:289) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) [junit-4.12.jar:4.12]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:291) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:246) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:97) [spring-test-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) [junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) [junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) [junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) [junit-4.12.jar:4.12]
at org.junit.runners.ParentRunner $KaTeX parse error: Expected 'EOF', got '\workspace' at position 1900: …ned in file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ doGetBean $KaTeX parse error: Expected 'EOF', got '\workspace' at position 2555: …ned in file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ doGetBeanResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:618) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata $KaTeX parse error: Expected 'EOF', got '\workspace' at position 775: …ned in file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ doGetBeanResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:618) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata $KaTeX parse error: Expected 'EOF', got '\workspace' at position 606: …ned in file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ doGetBean $0 (A b s t r a c t B e a n F a c t o r y . j a v a : 317) [s p r i n g - b e a n s - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . D e f a u l t S i n g l e t o n B e a n R e g i s t r y . g e t S i n g l e t o n (D e f a u l t S i n g l e t o n B e a n R e g i s t r y . j a v a : 228) [s p r i n g - b e a n s - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . d o G e t B e a n (A b s t r a c t B e a n F a c t o r y . j a v a : 315) [s p r i n g - b e a n s - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . b e a n s . f a c t o r y . s u p p o r t . A b s t r a c t B e a n F a c t o r y . g e t B e a n (A b s t r a c t B e a n F a c t o r y . j a v a : 204) [s p r i n g - b e a n s - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . a n n o t a t i o n . C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r . a u t o w i r e R e s o u r c e (C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r . j a v a : 513) [s p r i n g - c o n t e x t - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . a n n o t a t i o n . C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r . g e t R e s o u r c e (C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r . j a v a : 484) [s p r i n g - c o n t e x t - 5.0.6 . R E L E A S E . j a r : 5.0.6 . R E L E A S E] a t o r g . s p r i n g f r a m e w o r k . c o n t e x t . a n n o t a t i o n . C o m m o n A n n o t a t i o n B e a n P o s t P r o c e s s o r$ ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:618) ~[spring-context-5.0.6.RELEASE.jar:5.0.6.RELEASE]
at org.springframework.beans.factory.annotation.InjectionMetadata $KaTeX parse error: Expected 'EOF', got '\workspace' at position 616: …ned in file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ doGetBean $KaTeX parse error: Expected 'EOF', got '\workspace' at position 872: …urce: 'file [D:\̲w̲o̲r̲k̲s̲p̲a̲c̲e̲\demo\userManag…$ StrictMap.put(Configuration.java:872) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:844) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.session.Configuration.addMappedStatement(Configuration.java:668) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:302) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:109) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:135) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:128) ~[mybatis-3.4.5.jar:3.4.5]
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:118) ~[mybatis-3.4.5.jar:3.4.5]
… 100 common frames omitted