【MyBatis】 Mapped Statements collection already contains value for *** 错误

最新推荐文章于 2022-09-27 07:08:29 发布
最新推荐文章于 2022-09-27 07:08:29 发布
阅读量760 收藏
点赞数
分类专栏： MyBatis JAVA SpringBoot 文章标签： mybatis spring boot spring
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/fulin9452/article/details/105647939
版权
JAVA 同时被 3 个专栏收录
6 篇文章 0 订阅
订阅专栏
MyBatis
1 篇文章 0 订阅
订阅专栏
SpringBoot
1 篇文章 0 订阅
订阅专栏
  • 错误：java.lang.IllegalArgumentException: Mapped Statements collection already contains value for ***
  • 环境：springboot
  • 错误原因： MyBatis不允许有重名方法，更改方法名称即可
  • 参考：stackoverflow
  • 完整错误代码
java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.xu.miaosha.dao.OrderDao.insert. please check com/xu/miaosha/dao/OrderDao.java (best guess) and com/xu/miaosha/dao/OrderDao.java (best guess)
	at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:947) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.session.Configuration$StrictMap.put(Configuration.java:903) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.session.Configuration.addMappedStatement(Configuration.java:702) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:297) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parseStatement(MapperAnnotationBuilder.java:358) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.builder.annotation.MapperAnnotationBuilder.parse(MapperAnnotationBuilder.java:139) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.binding.MapperRegistry.addMapper(MapperRegistry.java:72) ~[mybatis-3.5.3.jar:3.5.3]
	at org.apache.ibatis.session.Configuration.addMapper(Configuration.java:775) ~[mybatis-3.5.3.jar:3.5.3]
	at org.mybatis.spring.mapper.MapperFactoryBean.checkDaoConfig(MapperFactoryBean.java:80) ~[mybatis-spring-2.0.3.jar:2.0.3]
	at org.springframework.dao.support.DaoSupport.afterPropertiesSet(DaoSupport.java:44) [spring-tx-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1290) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1210) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1422) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1290) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1210) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:640) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:130) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessProperties(AutowiredAnnotationBeanPostProcessor.java:399) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1422) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:882) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878) ~[spring-context-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) ~[spring-context-5.2.5.RELEASE.jar:5.2.5.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) ~[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) ~[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) ~[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) ~[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) ~[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) ~[spring-boot-2.2.6.RELEASE.jar:2.2.6.RELEASE]
	at com.xu.miaosha.MainApplication.main(MainApplication.java:16) ~[classes/:na]
没错是长青呀
关注
专栏目录
mybatis报错Mapped Statements collection already contains value
sh3ine的博客
05-01 310
错误描述 最近部署ssm项目时出错，错误为 Mapped Statements collection already contains value for xxx包.xxxmapper.xxx方法 部署项目时，第一次使用了maven+mybatis generator，由于第一次使用逆向工程，一次性生成了许多方法，添加方法时，忘记更改项目id 处理弯路 在spring中配置mybatis的mapp...
关于Mapped Statements collection already contains value for dao.BookMapper.addBook报错原因及解决
weixin_47726842的博客
03-18 310
关于 Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for dao.BookMapper.addBook报错 这里是一个mappeer被注册了多次 即在Spring-dao.xml中配置SqlSessionFactory中配置了mapperLocations且value指定了扫描包 这里已经对mapper.xml完成注册 <!--SqlSessionF
解决报错：Mapped Statements collection already contains value for...
zzztimes的博客
12-03 4869
这种情况通常情况下是由于Mapper映射xml文件中SQL标签的id属性重复导致的，仔细检查是否有相同的sql方法名称。 解决方法： 1.检查是否有重复id标签的sql； 2.配置项mybatis: mapper-locations:重复，导致在程序加载时，多次编译xml文件，一个方法被加载两次，就会检测到重复； 我遇到的是第二种情况，确定自己的xml确实不存在重复的sql方法名，检查到我这里的配置项重复： mybatis: mapper-locations: # - classpat
Mybatis报错Mapped Statements collection already contain...
老秦的博客
07-09 687
早上起来启动项目报错： Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for xxx.xxx.xxxx... Caused by: org.apache.ibatis.builder.BuilderException: Error parsin...
Mapped Statements collection already contains value
weixin_51131291的博客
07-02 485
今天来分享一下让人让我有点抓脑的问题！！ 这一阵子都在自学Mybatis,昨天学的多表查询，多对一的关系查询中出现了一个报错，其实也是很简单的问题，但稍不注意就会让人抓耳挠腮。 在数据库的字段名中有些事下划线命名，而对应的实体类一般会是驼峰命名，解决字段名和属性名不一致的方法有三种：a->:为字段起别名b->: 设置全局变量，将自动映射为驼峰 <setting name="mapUnderscoreToCamelCase" value="true"/&
解决Spring Boot报错Mapped Statements collection already contains value for...Error while adding the mapp
暗诺星刻的博客
03-08 4887
解决Spring Boot报错Mapped Statements collection already contains value for...Error while adding the mapper   今天，在笔者刚刚编写完一个上万行的 SpringBoot 项目后，第一次运行时，一运行果然马上就报错了。笔者从来没有哪一次是代码编写完就一次性通过的，显然这次也不例外。经过这次报错得到的教训是：一定要及时勤劳地编写单元测试。把单元测试拖到所有 Bug 全部查完之后再编写没有任何意义。 笔者报错时的运
异常 java.lang.IllegalArgumentException: Mapped Statements collection already contains value for 解决
热门推荐
照母山挖洋芋
07-03 1万+
异常信息： org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:437) - Scanned package: 'com.***.entity' for aliases org.mybatis.spring.SqlSessionFactoryBean.buildSql...
如何解决Mybatis--java.lang.IllegalArgumentException: Result Maps collection already contains value for X
08-31
在整合Spring、Struts2和Mybatis的过程中，可能会遇到各种问题，其中之一就是`java.lang.IllegalArgumentException: Result Maps collection already contains value for X`。这个问题通常出现在Mybatis配置文件中，...
Mapped Statements collection already contains value for com.
最新发布
09-09
Mapped Statements collection already contains value for com.是一个报错信息，通常与MyBatis框架相关。这个错误表示在MyBatis的映射文件中，有多个相同的Mapped Statement被定义了，导致冲突。 解决这个问题的...
Mapped Statements collection already contains value for...问题解决
qq_42133677的博客
06-14 467
Mapped Statements collection already contains value for…问题解决 情况1： 就是方法id重复了，但不一定是xxx重复，而有可能是yyy。所以最好是把新旧代码做个diff，看看都加了哪些方法，逐个去排查； 情况2：方法参数写错了或者没写。比如resultType="UserVO"写成了resultType=“User”。这种情况一般是最近删除了什么bean或者重命名了什么bean而xml对应的参数类型没有修改而导致的。同样的，mybatis并不一定能准确
Mapped Statements collection already contains value for test.deleteUser
u010746364的博客
11-08 400
org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession. ### The error may exist in User.xml ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper C
Mapped Statements collection already contains value for ... 报错原因及解决办法
weixin_46030002的博客
09-27 6465
Mapped Statements collection already contains value for ... 报错原因及解决办法
MyBatis Mapped Statements collection already contains value for xx.please check file [x]
旭东怪的博客
11-01 528
问题描述： Caused by: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.mapper.UserMapper.getUserList. please check file [D:\idea 2015\springsecuritydemon\target\classes\mapper\UserMapper.xml] and file [D:\...
Mybatis出现Mapped Statements collection already contains value for
赵小叔
11-12 2279
Mybatis出现Mapped Statements collection already contains value for  错误原因： 1.mapper中存在id重复的值 2.mapper中的parameterType或resultType为空。 例如：
【报错】Result Maps collection already contains value for XXXX 但是没有重复id
u013248911的博客
08-17 1万+
原来是一个mapper进行了两次映射加载，因此要注释掉其中一个。 applicationContext.xml &lt;bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"&gt;           &lt;property name="dataSource" ref="dataSource"...
Mybatis报错——Mapped Statements collection already contains value for 。。。
kingscoming的博客
12-25 1万+
Mybatis报错——Mapped Statements collection already contains value for com.mapper.EmployeeMapperPlus.getEmpByIdDe异常如下：org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession. ###
记录Mybatis报Mapped Statements collection already contains value for 的错误的原因
gill__hong的博客
07-02 2215
在一次提供升级包让同事升级后，启动服务时出现Mybatis报Mapped Statements collection already contains value for 的错误，导致无法启动。 1.首先查看了报错的xml文件，里面是否有重复的id，id没有重复的。 2.在网上查到，当parameterType和resultType参数错误或者为空时也会报相应的错误，因为那个报错的查询语句resultType是一个实体类，怀疑是该类没有升级，检查发现是有这个类的。 3.怀疑mybatis的配置文件里配置了
不同 Mapper XML 文件中 id 是否可以相同？
ConstXiong
10-13 1766
新版本 Mapper XML mapper 标签的 namespace 参数值不能为空 两个 Mapper XML mapper 标签的 namespace 参数值相同，id 不可以相同。否则，提示异常 Mapped Statements collection already contains value 两个 Mapper XML mapper 标签的 namespace 参数值不同，id 可以相同 从源码实现上看，namespace.id 是 MappedStateme..
关于Mybatis出现Mapped Statements collection already contains value for XXX 错误(相对较全)
weixin_41671621的博客
03-11 3728
Mybatis出现Mapped Statements collection already contains value for 错误 在我们开发过程中有时会遇到这个问题，大体意思是mapper映射集合的值已存在，那么在此记录下我遇到此问题的寻找过程，小白一枚，不喜勿喷，有大佬看出问题请多指教… 在此过程中我也查询了许多相关博客，各种百度贴吧，然后总结了我自己认为可能的一些错误。 先从做简单的开始...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值