mybatis和spring整合时这个报错，应该这样解决！

末蓝、 2022-12-31 07:23 144阅读 0赞

![format_png][]

# 01 #

问题描述

今天在写mybatis和spring整合的时候，出现了个问题，其实也没有多难，就是自己没有仔细看，特此记录一下。

报错问题如下：

![format_png 1][]

![format_png 2][]

org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'empService' defined in class path resource [applicationContext.xml]: Initialization of bean failed; nested exception is org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'org.mybatis.spring.mapper.MapperScannerConfigurer' to required type 'org.dao.EmpDaoMapper' for property 'empDao'; nested exception is java.lang.IllegalStateException: Cannot convert value of type [org.mybatis.spring.mapper.MapperScannerConfigurer] to required type [org.dao.EmpDaoMapper] for property 'empDao': no matching editors or conversion strategy found
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:529)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
      at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
      at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
      at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
      at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
      at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:636)
      at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:934)
      at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479)
      at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:139)
      at org.springframework.context.support.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:83)
      at org.test.TestMain.before(TestMain.java:21)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      at java.lang.reflect.Method.invoke(Method.java:606)
      at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
      at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
      at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
      at org.junit.internal.runners.statements.RunBefores.evaluate(RunBefores.java:27)
      at org.junit.runners.BlockJUnit4ClassRunner.runNotIgnored(BlockJUnit4ClassRunner.java:79)
      at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:71)
      at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:49)
      at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
      at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
      at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
      at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
      at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
      at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
      at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:50)
      at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
      at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
    Caused by: org.springframework.beans.ConversionNotSupportedException: Failed to convert property value of type 'org.mybatis.spring.mapper.MapperScannerConfigurer' to required type 'org.dao.EmpDaoMapper' for property 'empDao'; nested exception is java.lang.IllegalStateException: Cannot convert value of type [org.mybatis.spring.mapper.MapperScannerConfigurer] to required type [org.dao.EmpDaoMapper] for property 'empDao': no matching editors or conversion strategy found
      at org.springframework.beans.BeanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:464)
      at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:495)
      at org.springframework.beans.BeanWrapperImpl.convertForProperty(BeanWrapperImpl.java:489)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.convertForProperty(AbstractAutowireCapableBeanFactory.java:1465)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1424)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1160)
      at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
      ... 34 more
    Caused by: java.lang.IllegalStateException: Cannot convert value of type [org.mybatis.spring.mapper.MapperScannerConfigurer] to required type [org.dao.EmpDaoMapper] for property 'empDao': no matching editors or conversion strategy found
      at org.springframework.beans.TypeConverterDelegate.convertIfNecessary(TypeConverterDelegate.java:267)
      at org.springframework.beans.BeanWrapperImpl.convertIfNecessary(BeanWrapperImpl.java:449)
      ... 40 more

下面是spring的所有配置文件信息：

配置数据源信息：

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
        <property name="url" value="jdbc:mysql://localhost:3306/schooldb"></property>
        <property name="username" value="root"></property>
        <property name="password" value="root"></property>
      </bean>

配置SqlSessionFactory信息，以及加载数据源：

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        
        <property name="mapperLocations">
          <list>
            <value>classpath:org/dao/*/*.xml</value>
          </list>
        </property>
        
        <property name="configLocation" value="classpath:mybatis-config.xml"></property>
      </bean>

使用MapperScannerConfigurer注入映射器：

<bean id="empDao" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="org.dao"></property>
      </bean>

下面就是配置Service层：

问题就出在“**配置Service层**”这一步，原来在未使用MapperScannerConfigurer的时候，程序是可以正常跑起来的，但是加上MapperScannerConfigurer，程序就报错，找了好半天，终于发现，原来粗心的将对象名写错了，下面是问题的解决方式：

# 02 #

解决问题

更正MapperScannerConfigurer注入映射器和empService注入映射器，代码如下：

<bean  class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="org.dao"></property>
      </bean>
      
      <bean id="empService" class="org.service.impl.EmpServiceImpl">
        <property name="empDao" ref="empDaoMapper"></property>
      </bean>

然后运行项目，正常执行：

![format_png 3][]

# 03 #

分析问题

当我们使用MapperScannerConfigurer注入映射器时，可以不用Mapper的实现类，但是Mapper的接口名必须要与所对应的SQL映射文件名一模一样，且接口中的方法名需与SQL映射文件的id名相同。

![format_png 4][]

![format_png 5][]

![format_png 6][]

通过MapperScannerConfigurer可以批量生成映射器实现，映射器被注册到Spring的容器时，spring会自动根据其接口名给其命名，默认规则是首字母小写的非完全限定名。比如上面代码中的接口名为EmpDaoMapper,那默认命名就是empDaoMapper,原来在ref引入对象的时候，写的是empDao，所以就报错。改成其默认的命名empDaoMapper问题解决。

希望大家在整合框架的时候，能认真细心，避免出现没必要的bug，耽误时间。

**辣椒酱，了解下呗~**

![format_png 7][]

**往期精彩**

[考研生的努力程度是有多恐怖！][Link 1]

[2020-12-27][Link 1]

[![format_png 8][] ][Link 1]

[越优秀的人越努力，越努力的人越幸运！][Link 2]

[2020-12-26][Link 2]

[![format_png 9][] ][Link 2]

[“老师，为什么我一上课就感到困，听课听的总是走神？”][Link 3]

[2020-12-25][Link 3]

[![format_png 10][] ][Link 3]

[最好的方法，是为你们量身定制！][Link 4]

[2020-12-23][Link 4]

[![format_png 11][] ][Link 4]

[“桌面日历”记录的事件居然是看某某视频……][Link 5]

[2020-12-21][Link 5]

[![format_png 12][] ][Link 5]

![format_png 13][]

![format_png 14][]

点分享

![format_png 15][]

点点赞

![format_png 16][]

点在看

[format_png]: /images/20221120/0a9979a3bfee48588a4e838fb6439c54.png
[format_png 1]: /images/20221120/5184ecfb467749829e9cabc573d05238.png
[format_png 2]: /images/20221120/435e65c3d54f4464b4d35b301737ab77.png
[format_png 3]: /images/20221120/8766c69b16294a45a53c8c99033ac704.png
[format_png 4]: /images/20221120/e2bb6d14d71b46d08d833b1875756a74.png
[format_png 5]: /images/20221120/1795442fa2b3400b8a534d9aae2978db.png
[format_png 6]: /images/20221120/1131e130a69f4631b857ce5e5ffb129c.png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9EWjlUaWF4ZFF4azNKT2dwb2V3aWFXTHpqRlNwSDhQM1dtZGNkaGtNaWFJckd6aWFRbndnYVczeURrQzB1Q1R2Z1VtQnFPZ3pOaWFWcFFudU84eHFiaWNGVGVGQS82NDA?x-oss-process=image/format,png
[Link 1]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fe129a0f8683fb930a13d0afc805a909d6f5bff8a13196fa388d6abef92dc6066416b9b22&idx=1&mid=2247498696&scene=21&sn=30aad547accff4eb705f9347598e77f0#wechat_redirect
[format_png 8]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9EWjlUaWF4ZFF4azFMUTJnVUNqd2VzNUpQN3NUcHJoQ3R4STVLYlQyUkRrRlRIeUxtSmcwOE02YkV1d21wS2FpYmpQU1JHaFRsYmdOMWNWa1RwMnVsZzZRLzY0MA?x-oss-process=image/format,png
[Link 2]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fe151a0f86847e638e097187efd14258a28fd9a33d5bd127a08edaf3b960c6943c8bc8414&idx=1&mid=2247498672&scene=21&sn=7605fa60f794ac4dff074d0c40e524e5#wechat_redirect
[format_png 9]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9EWjlUaWF4ZFF4azFweGRpYWtPamVUTTM2WFRldm1veHBQV1NoQTlzaWFDcDRpYVVrOTBwSGV4MW91ZmxoZmIxamljMVM0d3k0YjU0UFA1WldKdWljWVlxN0hCQS82NDA?x-oss-process=image/format,png
[Link 3]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fe177a0f86861520e52730809ce93d6282e1dee3953893459208e34d5e8dc05fa88f9db4e&idx=1&mid=2247498646&scene=21&sn=43f8d6d2f2b61130ee44c4abcffa12f7#wechat_redirect
[format_png 10]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9EWjlUaWF4ZFF4azA1TnNKeVpVcEhpYk53aDQzSWNlaDRvWWY2YkZtMzkzeVY0U1VvWnl6OG5QcjZ0a0NHRHZRU2pNbGhTQ25WWWNTYjlvZ0lNVzBqZDNRLzY0MA?x-oss-process=image/format,png
[Link 4]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fe192a0f868849f61fb5dd6ece5c3c43b06073de2441e465e3508f67d3827ac06b49fb005&idx=1&mid=2247498611&scene=21&sn=2a7a7a4a6a1624fe0b2bb4382829363d#wechat_redirect
[format_png 11]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9EWjlUaWF4ZFF4azNEczBYWGRpYWhteUE0NWVERHVUdDFrRWt3Uk1MekoweW5BRFVocWZuZE1pY2pjWThza2xpYTZsaEFHUFVYMlc3aWFlY0dPblh3M0JUNGljZy82NDA?x-oss-process=image/format,png
[Link 5]: http://mp.weixin.qq.com/s?__biz=MzIxNjE1ODA5NA%3D%3D&chksm=978fe1b7a0f868a14011edac9bbe8e2970485fdcae7c57269600d4da11204fda5c5007cb4e2d&idx=1&mid=2247498582&scene=21&sn=cbed49bf5bb7f86325265730063331df#wechat_redirect
[format_png 12]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2pwZy9EWjlUaWF4ZFF4azFmWHFYc0NSMlBFZU14c0dSM1BHV1VuSEpaRW5OZGptcVJhcmpha21hb3NGN2VubkUwSUNXNEtzYXpSd2liaWM2eDlPMjhmWXpsNUllUS82NDA?x-oss-process=image/format,png
[format_png 13]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9EWjlUaWF4ZFF4azBGcWJjaWNLTXJlSUxrN3EwdldXc0pyTXpIaE5sZXppYzJXc3B2UjdUSzBEcEo4UnJjTXFjRDEzWU5jTDk0ekhzdktvemljeFZZWElNencvNjQw?x-oss-process=image/format,png
[format_png 14]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9EWjlUaWF4ZFF4azFPclNvckhkaWM4dlRXMmVWbFpSUzVaOGUxcUJpY2xGMEo3UzE1WmgzOEtzejRlTWliaWJzQVl4ajF5ZEZrNmliQlBBdFN3c3BpYjVETmliMUZRLzY0MA?x-oss-process=image/format,png
[format_png 15]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9EWjlUaWF4ZFF4azFPclNvckhkaWM4dlRXMmVWbFpSUzVaZE1rWUVJUTY4bWF6YWxLTkxZUFdtWDZ0Y2d2RjZpYjhnZ3pxMTVNUER5aWFaR3hxeGxSaWJNMDhnLzY0MA?x-oss-process=image/format,png
[format_png 16]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9EWjlUaWF4ZFF4azFPclNvckhkaWM4dlRXMmVWbFpSUzVaRTVpY3RyS0JvYWlid0l4aWNack11RE9YM0J6c0dPaExMWWdqMFM1NHVITGliREt2VGZqbktGOE9xQS82NDA?x-oss-process=image/format,png