报错信息:
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>