java.lang.IllegalArgumentException: Mapped Statements collection does not contai in value for .....

最新推荐文章于 2023-07-20 10:51:55 发布

说：/~不了

最新推荐文章于 2023-07-20 10:51:55 发布

阅读量1.2k

点赞数

分类专栏： mybatis

mybatis 专栏收录该内容

35 篇文章 0 订阅

订阅专栏

Java代码

java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.XX.dao.UserMapper.getUserList
at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:775)
at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:615)
at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:608)
at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:176)
... 50 more

java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for com.XX.dao.UserMapper.getUserList
	at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:775)
	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:615)
	at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:608)
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:176)
	... 50 more

错误1代码

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.XX.dao.UserMapper.getUserList
at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:178)
at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:38)
at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:49)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:42)

 org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.XX.dao.UserMapper.getUserList
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:178)
	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:38)
	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:49)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:42)

最近在用mybatis出现上次错误，原因：

Xml代码

<bean id="sqlSessionFactory"
class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="typeAliasesPackage" value="com.XX" />
</bean>

<!-- define the SqlSessionFactory -->
	<bean id="sqlSessionFactory"
		class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<!--<property name="configLocation" value="classpath:mybatis-conf.xml" />-->
		<property name="typeAliasesPackage" value="com.XX" />
	</bean>

sqlSessionFactory上并未注册或获取到*mapper.xml里面的sql语句信息，造成这个原因无非就是：

*mapper.xml未找到或里面的sql中跟mapper接口中的方法不对应。

总之，从sqlSessionFactory或xml中入手，很容易揪出错的，而且配置这块经常容易出问题，尤其对mybatis不熟或首次集成的time！

有可能是在配置文件中没有导入映射文件