电商平台学习笔记（三）——Mybatis启动异常org.apache.ibatis.type.TypeException

最新推荐文章于 2024-07-27 21:31:09 发布
最新推荐文章于 2024-07-27 21:31:09 发布
阅读量1.3w 收藏 1
点赞数 1
分类专栏： 框架学习 文章标签： mybatis exception
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/renshengkudaun/article/details/51048917
版权
今天一大早刚过来写代码，接着昨天使用MapperScannerConfigurer来扫包！以帮助从DAO层解脱出来（只需要定义接口）！结果就遇到了Bug。
异常内容如下： 
java.lang.IllegalStateException: Failed to load ApplicationContext
	at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:124)
	at org.springframework.test.context.support.DefaultTestContext.getApplicationContext(DefaultTestContext.java:83)
	at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.injectDependencies(DependencyInjectionTestExecutionListener.java:117)
	at org.springframework.test.context.support.DependencyInjectionTestExecutionListener.prepareTestInstance(DependencyInjectionTestExecutionListener.java:83)
	at org.springframework.test.context.TestContextManager.prepareTestInstance(TestContextManager.java:228)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.createTest(SpringJUnit4ClassRunner.java:230)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner$1.runReflectiveCall(SpringJUnit4ClassRunner.java:289)
	at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.methodBlock(SpringJUnit4ClassRunner.java:291)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:249)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:89)
	at org.junit.runners.ParentRunner$3.run(ParentRunner.java:238)
	at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:63)
	at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:236)
	at org.junit.runners.ParentRunner.access$000(ParentRunner.java:53)
	at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:229)
	at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61)
	at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:309)
	at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:193)
	at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86)
	at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382)
	at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'brandServiceImpl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'brandDao' defined in file [E:\WorkSpace\NewBaBaSport\BaBaSport\target\classes\cn\ilxy\dao\product\BrandDao.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory': Error creating bean with name 'sqlSessionFactory' defined in file [E:\WorkSpace\NewBaBaSport\BaBaSport\target\classes\config\mybatis.xml]: Invocation of init method failed; nested exception is org.apache.ibatis.type.TypeException: The alias 'BrandQuery' is already mapped to the value 'cn.ilxy.query.BrandQuery'.; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in file [E:\WorkSpace\NewBaBaSport\BaBaSport\target\classes\config\mybatis.xml]: Invocation of init method failed; nested exception is org.apache.ibatis.type.TypeException: The alias 'BrandQuery' is already mapped to the value 'cn.ilxy.query.BrandQuery'.
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessPropertyValues(CommonAnnotationBeanPostProcessor.java:311)
	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.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:772)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:839)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:538)
	at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:125)
	at org.springframework.test.context.support.AbstractGenericContextLoader.loadContext(AbstractGenericContextLoader.java:60)
	at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.delegateLoading(AbstractDelegatingSmartContextLoader.java:109)
	at org.springframework.test.context.support.AbstractDelegatingSmartContextLoader.loadContext(AbstractDelegatingSmartContextLoader.java:261)
	at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContextInternal(DefaultCacheAwareContextLoaderDelegate.java:98)
	at org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate.loadContext(DefaultCacheAwareContextLoaderDelegate.java:116)
	... 25 more
Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'brandDao' defined in file [E:\WorkSpace\NewBaBaSport\BaBaSport\target\classes\cn\ilxy\dao\product\BrandDao.class]: Unsatisfied dependency expressed through bean property 'sqlSessionFactory': Error creating bean with name 'sqlSessionFactory' defined in file [E:\WorkSpace\NewBaBaSport\BaBaSport\target\classes\config\mybatis.xml]: Invocation of init method failed; nested exception is org.apache.ibatis.type.TypeException: The alias 'BrandQuery' is already mapped to the value 'cn.ilxy.query.BrandQuery'.; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in file [E:\WorkSpace\NewBaBaSport\BaBaSport\target\classes\config\mybatis.xml]: Invocation of init method failed; nested exception is org.apache.ibatis.type.TypeException: The alias 'BrandQuery' is already mapped to the value 'cn.ilxy.query.BrandQuery'.
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1307)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1199)
	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.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:512)
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:486)
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:615)
	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:308)
	... 41 more
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in file [E:\WorkSpace\NewBaBaSport\BaBaSport\target\classes\config\mybatis.xml]: Invocation of init method failed; nested exception is org.apache.ibatis.type.TypeException: The alias 'BrandQuery' is already mapped to the value 'cn.ilxy.query.BrandQuery'.
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1578)
	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.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1116)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1014)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1292)
	... 54 more
Caused by: org.apache.ibatis.type.TypeException: The alias 'BrandQuery' is already mapped to the value 'cn.ilxy.query.BrandQuery'.
	at org.apache.ibatis.type.TypeAliasRegistry.registerAlias(TypeAliasRegistry.java:157)
	at org.apache.ibatis.type.TypeAliasRegistry.registerAlias(TypeAliasRegistry.java:147)
	at org.apache.ibatis.type.TypeAliasRegistry.registerAliases(TypeAliasRegistry.java:136)
	at org.mybatis.spring.SqlSessionFactoryBean.buildSqlSessionFactory(SqlSessionFactoryBean.java:395)
	at org.mybatis.spring.SqlSessionFactoryBean.afterPropertiesSet(SqlSessionFactoryBean.java:355)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1637)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1574)
	... 64 more
各位看官注意了，凭我看Mybatis这么多的异常的经验来看，一般java.lang.IllegalStateException: Failed to load ApplicationContext异常信息在最上面，多半是你写的配置文件有问题，这次我也是的。我利用Junit测试时，没有调用任何业务逻辑方法时也是报这个错误！
异常信息是说，Spring在扫包时，已经发现 BrandQuery别名和 cn.ilxy.query.BrandQuery类已经形成了对应关系，在继续扫描的过程中又发现了一个名为 BrandQuery的类，故报此异常！后来看了看项目目录（如下图）：
Mybatis启动异常org.apache.ibatis.type.TypeException - 享受孤独 - 享受孤独的博客
各位看官看明白了没有，出现了两个名为BrandQuery的实体类！故报此异常！
解决方案：每个类名必须是独一无二的！不得重名！相信各位看官知道怎么改了吧！改类名就行了啦！分享出来，希望对各位程序猿对所帮助，少走弯路！
既然选择了远方，就应风雨兼程！ --送给未来最好的自己


estelle1728
关注
专栏目录
Mybatis报错: org.apache.ibatis.exceptions.PersistenceException解决办法
09-09
主要介绍了Mybatis报错: org.apache.ibatis.exceptions.PersistenceException解决办法的相关资料,需要的朋友可以参考下
Cause: org.apache.ibatis.type.TypeException问题解决
Brave_heart4pzj的博客
04-30 4407
我这里的情形是在mapper.xml文件中用了实体类的别名，但是，别名无效导致这个错误 所以，要仔细检查xml中引用的外部文件是否能正确引用到 https://blog.csdn.net/weixin_43889841/article/details/104192538 ...
org.springframework.beans.factory.UnsatisfiedDependencyException
最新发布
m0_74613536的博客
07-27 630
Service@Autowired附。
【SpringBoot项目报错】整合MybatisPlus后，启动项目报错：org.apache.ibatis.type.TypeException
lilichalilicha的博客
08-08 623
原因： xxxMapper.xml 中的 resultType 找不到类。解决方法：把mybatis改为mybatis-plus的配置即可。
昨天出现了一些错误
weixin_46126405的博客
04-15 171
Cause: org.apache.ibatis.type.TypeException Error parsing SQL Mapper Configuration. Error creating bean with name ‘sqlSessionFactory’ defined in class path resource org.springframework.web.context.ContextLoader.initWebApplicationContext 诸如这些错误 根本原因是因为编写map
学习 MyBatis 时遇到的坑，Cause: java.sql.SQLFeatureNotSupportedException
trsnbb的博客
03-20 1500
Cause: java.sql.SQLFeatureNotSupportedException
Mybatis学习笔记大全.docx
09-24
MyBatis是一个基于Java的持久层框架，原先是Apache的iBatis项目，后于2010年迁移到Google Code并更名为MyBatis，再后来在2013年11月转到GitHub上发展。这个框架的主要目标是简化数据库访问，特别关注SQL语句的编写，...
MyBatis3学习笔记.pdf
09-01
【MyBatis3学习笔记】 MyBatis是一个优秀的Java持久层框架，它的主要目标是简化数据库操作，将复杂的JDBC代码和手动设置参数与获取结果集的过程自动化。MyBatis的核心理念是将Java方法与SQL语句绑定，使得开发者...
【狂神说】mybatis学习总结笔记（全）PDF格式文档 MyBatis.pdf
01-04
MyBatis学习总结笔记 MyBatis是一个优秀的持久层框架，它支持自定义SQL、存储过程以及高级映射。MyBatis免除了几乎所有的JDBC代码以及设置参数和获取结果集的工作。MyBatis可以通过简单的XML或注解来配置和映射原始...
MyBatis第一天课堂笔记.docx
08-08
MyBatis 从前身为 Apache 的 iBatis 项目发展而来，历经多次迁移，最终在 Github 上活跃。 **1. 为什么要选择 MyBatis** MyBatis 被广泛采用的原因在于其相比其他持久层框架如 Hibernate，具备以下优势： 1. **...
Caused by: org.apache.ibatis.type.TypeException
qq_56637516的博客
10-14 1846
异常： Files\Java\jdk1.8.0_131\jre\lib\charsets.jar;D:\Program Files\Java\jdk1.8.0_131\jre\lib\deploy.jar;D:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\access-bridge-64.jar;D:\Program Files\Java\jdk1.8.0_131\jre\lib\ext\cldrdata.jar;D:\Program Files\Java\j
关于mybatis自定义类型转换器时报没有找到相应的控制器处理的问题
qq_37225699的博客
08-21 6262
mybatis的类型转换器typeHandler是mybatis用于Java类型与数据库类型之间的转换用到的东西，事实上mybatis的typeHandler已经能够应对大部分的场景了，但是有时候也会不够用，比如在使用枚举的时候，枚举有特殊的转化规则，这时就需要用到自定义的类型转换器来处理了。 我在使用时出现了两次这样类似的异常如图： org.apache.ibatis.exception...
Mybatis遇见org.apache.ibatis.type.TypeException异常
sinat_40380134的博客
03-06 5468
问题描述： 在使用Mybatis注解配置模糊查询时，发生了org.apache.ibatis.type.TypeException的异常。之前对其他的CRUD进行测试都正常 详细的问题信息： org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.ibat...
Mybatis报错org.apache.ibatis.type.TypeException
热门推荐
l616769490的专栏
12-02 1万+
今天在写Mybatis时报错： org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='name', mode=IN, javaType=class java.lang.Integer, jdbcType=VARCHAR, numericScale...
mybatis报“Invalid value for getInt()“
qigeminghao的博客
10-31 1318
使用mybatis遇到一个非常奇葩的问题，错误如下： Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'name' from result set. Cause: java.sql.SQLException: Invalid value for getInt() - 'wo' 场景 还原一下当时的情况： public interface UserMapper
Mybatis异常分析之 org.apache.ibatis.executor.result.ResultMapException
代码缔造者的博客
03-20 9251
前文 本文章主要正对org.apache.ibatis.executor.result.ResultMapException 异常出现情况分析。从原理角度明白为啥会有这样的异常，以后不管那种场景下，明白原理后，不需要百度自己即可知道问题的根源。 怎么会出现这样错误 情况一 情况二 通过源码分析原理 如何解决 情况一解决 对象类型值与mysql 一一对应 情况二解决 剔除注解@Builder 或者@AllArgsConstructor 代理生成构造方法注解都要剔除。 第一条不剔除的话，按照数据库查询出
mybatis中Error attempting to get column ‘xx‘ from result set 问题解决
guily_kiss的博客
03-01 6831
文章部分摘要:https://www.cnblogs.com/asplover/p/12376550.html
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6fb7aad5]
09-03
23:01:01.765 [Service socket Server-Manager-0-Eexecutor3] DEBUG org.mybatis.spring.SqlSessionUtils - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6fb7aad5] 是一个日志输出，说明正在关闭一个非事务性的SqlSession对象。 SqlSession对象是MyBatis中与数据库交互的核心对象，它提供了执行SQL语句的方法。在MyBatis中，事务的处理是通过SqlSession对象来实现的。在这个日志输出中，关闭的是一个非事务性的SqlSession对象，这意味着该对象并没有参与到一个事务中。 在使用MyBatis进行数据库访问时，通常会开启一个事务来确保一组相关的操作要么全部成功，要么全部失败回滚。在事务中，可以使用SqlSession对象来执行SQL语句，并可以通过commit方法提交事务或者rollback方法回滚事务。 因此，Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@6fb7aad5] 可以理解为关闭一个非事务性的SqlSession对象。<span class="em">1</span><span class="em">2</span><span class="em">3</span> #### 引用[.reference_title] - *1* *2* [java.io.IOException: 远程主机强迫关闭了一个现有的连接。](https://blog.csdn.net/weixin_39806808/article/details/113466399)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] - *3* [Spring学习笔记](https://blog.csdn.net/qq_43144261/article/details/117278526)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"] [ .reference_list ]
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值