mybatis 异常信息

最新推荐文章于 2022-04-27 14:19:39 发布

wan_xiao

最新推荐文章于 2022-04-27 14:19:39 发布

阅读量361

点赞数

CC 4.0 BY-SA版权

分类专栏： ssm整合文章标签： mybatis

本文链接：https://blog.youkuaiyun.com/wan_xiao/article/details/84135035

ssm整合专栏收录该内容

1 篇文章

订阅专栏

给大家分享一下一个很奇葩的异常报错信息，报错的方法是queryall，但实际并不是，所以要仔细查找改动的代码。
ERROR [localhost-startStop-1] - Error while adding the mapper ‘interface com.maven.company.mapper.CompanyMapper’ to configuration.
org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.maven.company.mapper.CompanyMapper.queryAll
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:120)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.parse(XMLMapperBuilder.java:92)
at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.loadXmlResource(MapperAnnotationBuilder.java:166)
at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parse(MapperAnnotationBuilder.java:118)
at org.apache.ibatis.binding.MapperRegistry.addMapper(MapperRegistry.java:71)
at org.apache.ibatis.session.Configuration.addMapper(Configuration.java:651)
at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:97)
at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:44)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:545)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
at org.springframework.beans.factory.support.AbstractBeanFactoryAutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:566)
at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:349)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1214)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
at org.springframework.beans.factory.support.AbstractBeanFactoryStartChild.call(ContainerBase.java:1559)
at org.apache.catalina.core.ContainerBase $S t a r t C h i l d . c a l l (C o n t a i n e r B a s e . j a v a : 1549) a t j a v a . u t i l . c o n c u r r e n t . F u t u r e T a s k . r u n (F u t u r e T a s k . j a v a : 266) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r . r u n W o r k e r (T h r e a d P o o l E x e c u t o r . j a v a : 1142) a t j a v a . u t i l . c o n c u r r e n t . T h r e a d P o o l E x e c u t o r$ Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.maven.company.mapper.CompanyMapper.queryAll
at org.apache.ibatis.session.Configuration $S t r i c t M a p . p u t (C o n f i g u r a t i o n . j a v a : 782) a t o r g . a p a c h e . i b a t i s . s e s s i o n . C o n f i g u r a t i o n$ StrictMap.put(Configuration.java:754)
at org.apache.ibatis.session.Configuration.addMappedStatement(Configuration.java:578)
at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:288)
at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:107)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:135)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.buildStatementFromContext(XMLMapperBuilder.java:128)
at org.apache.ibatis.builder.xml.XMLMapperBuilder.configurationElement(XMLMapperBuilder.java:118)
… 48 more

最后在mapper.xml中的sql语句中找到了错误：
改动前:

update company set
company_name=#{company_name,address=#{address},setup_date=#{setup_date}
where company_id=#{company_id}

改动后：

update company set
company_name=#{company_name},address=#{address},setup_date=#{setup_date}
where company_id=#{company_id}

可以发现，在sql语句中掉了一个“}”导致了错误，所以这是一个很奇葩的错误，这些异常是要极力避免的。