Spring整合MyBatis错误：Mapped Statements collection does not contain value for

转载于： http://ifrenzyc.iteye.com/blog/1011593

 

MyBatis Mapper使用Spring注入：
applicationContext.xml

Xml代码  

1. <bean id="studentMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">  
2.     <property name="mapperInterface" value="com.itsyc.fmpp.mappers.StudentMapper" />  
3.     <property name="sqlSessionFactory" ref="sqlSessionFactory" />  
4. </bean>  

<bean id="studentMapper" class="org.mybatis.spring.mapper.MapperFactoryBean">
	<property name="mapperInterface" value="com.itsyc.fmpp.mappers.StudentMapper" />
	<property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>

使用上面方式注入时需要注意下面问题：
- interface = com.itsyc.fmpp.mappers.StudentMapper.class
- mapper file = /com/itsyc/fmpp/mappers/StudentMapper.xml
- mapper namespace = com.itsyc.fmpp.mappers.StudentMapper
这三者必须相同否则会出现下面错误：
Stacktraces
java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.itsyc.fmpp.mappers.StudentMapper.getById

2011-04-22更新：
软件版本：
mybatis: 3.0.4
spring: 3.0.5
mybatis-spring: 1.0.0

更正：mapper file是可以和interface、namespace不同的（注意：interface和namespace必须相同），但这时需要进行配置。
方式一：
1.在MyBatis配置文件中添加mappers：
mybatis-config.xml

Xml代码  

1. <mappers>  
2.     <mapper resource="com/itsyc/fmpp/mappers/StudentMapper.xml" /> <!-- Mapper文件可以和interface不在相同路径下！ -->  
3. </mappers>  

<mappers>
	<mapper resource="com/itsyc/fmpp/mappers/StudentMapper.xml" /> <!-- Mapper文件可以和interface不在相同路径下！ -->
</mappers>

2.使用configLocation，在Spring配置文件中添加MyBatis配置文件的引用：
applicationContext.xml

Xml代码  

1. <!-- MyBatis配置 -->  
2. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
3.     <property name="dataSource" ref="dataSource" />  
4.     <property name="configLocation" value="classpath:mybatis-config.xml" />  
5. </bean>  

<!-- MyBatis配置 -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="dataSource" ref="dataSource" />
	<property name="configLocation" value="classpath:mybatis-config.xml" />
</bean>

方式二：
使用mapperLocations，MyBatis-Spring会自动地扫描该路径下的所有Mapper文件：
applicationContext.xml

Xml代码  

1. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
2.     <property name="dataSource" ref="dataSource" />  
3.     <property name="mapperLocations" value="classpath*:com/itsyc/fmpp/mappers/*Mapper.xml" />  
4. </bean>  

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
	<property name="dataSource" ref="dataSource" />
	<property name="mapperLocations" value="classpath*:com/itsyc/fmpp/mappers/*Mapper.xml" />
</bean>

具体请查看mybatis-spring的参考手册：

• mybatis-spring-1.0.0-reference-simplified-chinese.pdf (692.8 KB)