【Mybatis报错】Error creating bean with name ‘sqlSessionFactory‘ defined in class path resource 报错_error creating bean with name 'sqlsessionfactory' -CSDN博客

本文链接：https://blog.csdn.net/zzzlueng/article/details/120840547

博客内容讲述了在整合Spring和MyBatis时遇到的Bean创建异常问题，具体表现为`MappedStatements collection already contains value`。错误原因是Spring配置文件和mybatis-config.xml中都指定了同一Mapper资源，导致重复配置。解决方案是删除其中一处配置，避免重复。

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

报错信息：

org.springframework.context.support.AbstractApplicationContext refresh
警告: Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [application.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'class path resource [mybatis/mapper/Studentmapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'class path resource [mybatis/mapper/Studentmapper.xml]'. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.wingchi.Dao.StudentDao.findStuById. please check mybatis/mapper/Studentmapper.xml and class path resource [mybatis/mapper/Studentmapper.xml]
Exception in thread "main" org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in class path resource [application.xml]: Invocation of init method failed; nested exception is org.springframework.core.NestedIOException: Failed to parse mapping resource: 'class path resource [mybatis/mapper/Studentmapper.xml]'; nested exception is org.apache.ibatis.builder.BuilderException: Error parsing Mapper XML. The XML location is 'class path resource [mybatis/mapper/Studentmapper.xml]'. Cause: java.lang.IllegalArgumentException: Mapped Statements collection already contains value for com.wingchi.Dao.StudentDao.findStuById. please check mybatis/mapper/Studentmapper.xml and class path resource [mybatis/mapper/Studentmapper.xml]

网上很多资料说是方法mybatis映射重名

在Spring配置文件中会配置sqlSessionFactory,一般配置如下：

   <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="ds"></property>
        <property name="configLocation" value="mybatis/mybatis-config.xml"></property>
<!--        扫描sql配置文件：mapper需要的xml文件 -->
        <property name="mapperLocations" value="mybatis/mapper/Studentmapper.xml"></property>
    </bean>

然后编写mybatis的配置文件：

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!-- settings -->
    <settings>
        <!-- 打开延迟加载的开关 -->
        <setting name="lazyLoadingEnabled" value="true"/>
        <!-- 将积极加载改为消极加载（即按需加载） -->
        <setting name="aggressiveLazyLoading" value="false"/>
        <!-- 打开全局缓存开关（二级缓存）默认值就是 true -->
        <setting name="cacheEnabled" value="true"/>
    </settings>
<!--    加载映射文件-->
    <typeAliases>   
        <package name="com.wingchi.beans"/>
    </typeAliases>
    <mappers>
        <mapper resource="mybatis/mapper/Studentmapper.xml"/>
    </mappers>
</configuration>

查来查去最后发现，其实Spring配置文件中的:

<property name="mapperLocations" value="mybatis/mapper/Studentmapper.xml"></property>

和mybatis文件中的：

    <mappers>
        <mapper resource="mybatis/mapper/Studentmapper.xml"/>
    </mappers>

指向的是同一个文件，所以如果两边都配置了，相当于重复配置，就会报错。

所以，随便将其中一处删掉就好了。

   <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="ds"></property>
        <property name="configLocation" value="mybatis/mybatis-config.xml"></property>
<!--        扫描sql配置文件：mapper需要的xml文件 -->
<!--        <property name="mapperLocations" value="mybatis/mapper/Studentmapper.xml"></property>-->
    </bean>