springBoot项目报错：org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):

最新推荐文章于 2024-02-29 15:12:55 发布

原创最新推荐文章于 2024-02-29 15:12:55 发布 · 538 阅读

本内容遵循CC 4.0 BY-SA版权协议

本文详细解析了在使用MyBatis框架时遇到的Mapper配置错误，具体为Invalid bound statement (not found): com.wan.springcloud.dao.DeptDao.queryAll。文章指导如何检查XML文件与Mapper接口的包名是否对应，以及方法名称与mapper.xml中的ID是否一致，帮助开发者快速定位并解决问题。

错误信息如下：
Whitelabel Error Page
This application has no explicit mapping for /error, so you are seeing this as a fallback.
Fri May 08 11:55:35 CST 2020
There was an unexpected error (type=Internal Server Error, status=500).
Invalid bound statement (not found): com.wan.springcloud.dao.DeptDao.queryAll
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.wan.springcloud.dao.DeptDao.queryAll
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:227)
	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:49)
	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:65)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
	at com.sun.proxy.$Proxy63.queryAll(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
	at java.lang.reflect.Method.invoke(Unknown Source)
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy65.queryAll(Unknown Source)

先说明我出错的原因，xml文件所在package名称没有和Mapper interface所在的包名一一对应
如果出现这样的错误，按以下的步骤排查错误
1，检查xml文件所在package名称是否和Mapper interface所在的包名一一对应；
2检查方法名称与mapper.xml的id是否对应；