调用mapper.xml自定义SQL报错-org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)

已于 2023-09-15 13:47:29 修改
阅读量494 收藏
点赞数 3
分类专栏： MyBatis Java异常处理 文章标签： xml java mybatis
于 2023-05-06 11:41:51 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_52116015/article/details/130523698
版权

目录

一、场景

1、原先项目上的mapper.xml都放到mappings/admin目录

2、在mappings/admin新增serviceflow目录，并存放mapper.xml文件

在这里插入图片描述

3、admin目录mapper.xml文件定义的SQL可以正常执行

4、serviceflow目录mapper.xml文件定义的SQL执行则报错

二、报错信息

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.xxx.mapper.admin.serviceflow.MbServiceflowconfigMapper.getList
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:225)
	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:48)
	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:65)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
	at com.sun.proxy.$Proxy143.getList(Unknown Source)
	at sun.reflect.GeneratedMethodAccessor367.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	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.$Proxy144.getList(Unknown Source)
	at com.xxx.service.admin.serviceflow.impl.MbServiceflowconfigServiceImpl.getList(MbServiceflowconfigServiceImpl.java:39)
	at com.xxx.controller.admin.serviceflow.ServiceFlowConfigController.getList(ServiceFlowConfigController.java:54)
	at com.xxx.controller.admin.serviceflow.ServiceFlowConfigController$$FastClassBySpringCGLIB$$7dea3d59.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:749)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:55)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.xxx.controller.admin.serviceflow.ServiceFlowConfigController$$EnhancerBySpringCGLIB$$c6dac1c0.getList(<generated>)
	at sun.reflect.GeneratedMethodAccessor366.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
	at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at com.xxx.power.jwt.a.doFilterInternal(JwtAuthenticationTokenFilter.java:192)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
	at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
	at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
	at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:357)
	at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:270)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1539)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1495)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)

三、排查

1、检查@MapperScan指定的包路径是否正确，配置正确

2、检查application配置文件的mapper-location属性是否配置正确，配置正确

3、检查dao文件方法名称与mapper.xml定义的SQL语句的ID，名称与ID都为getList

4、检查mapper.xml定义的namespace，指向的dao文件是正确的

四、原因

没有为serviceflow目录配置mapper扫描

以下为原先的mapper扫描配置

//注意：需要调用以下方法，传入相应数据源mapper映射才会生效
@Primary
@Bean("manageDataSourceSessionFactory")
public SqlSessionFactory manageDataSourceSessionFactory(DataSource dataSource) throws Exception {
	SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
	bean.setDataSource(dataSource);
	//这里只为admin目录配置了mapper扫描，却没有为serviceflow配置
	bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(String.format("classpath:mappings/%s/*.xml", "admin")));
	return bean.getObject();
}

五、解决

为serviceflow配置mapper扫描

调整后的mapper扫描配置

//注意：需要调用以下方法，传入相应数据源mapper映射才会生效
@Primary
@Bean("manageDataSourceSessionFactory")
public SqlSessionFactory manageDataSourceSessionFactory(DataSource dataSource) throws Exception {
	SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
	bean.setDataSource(dataSource);

	//admin、serviceflow都配置mapper扫描
	List<Resource> resources = new ArrayList();
	ResourcePatternResolver resourceResolver = new PathMatchingResourcePatternResolver();
	Resource[] mappers  = resourceResolver.getResources(String.format("classpath:mappings/%s/*.xml", "admin"));
	Resource[] mappers2  = resourceResolver.getResources(String.format("classpath:mappings/%s/%s/*.xml", "admin", "serviceflow"));
	resources.addAll(Arrays.asList(mappers));
	resources.addAll(Arrays.asList(mappers2));
	bean.setMapperLocations(resources.toArray(new Resource[resources.size()]));

	return bean.getObject();
}

六、补充

如果还无法解决问题，可以新增配置类，使用@MapperScan进行mapper扫描

@Configuration
@MapperScan(basePackages = {"com.xxx.dao.xxx"}, sqlSessionFactoryRef = "SessionFactory名称", sqlSessionTemplateRef = "SqlSessionTemplate名称")
public class xxxMapperScanConfiguration {
}
天黑请​闭眼
关注
专栏目录
解决org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):xxx问题
念兮为美
11-28 1万+
解决org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.cloud.lowcode.mapper.UserMapper.queryByParam问题
（报错记录）mybatis整合mybatis-plus错误org.apache.ibatis.binding.BindingException: Invalid bound statement
eggplantttttt的博客
03-21 1205
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.mindskip.xzs.repository.SubjectMapper.page at com.baomidou.mybatisplus.core.override.PageMapperMethod$SqlCommand.<init>(PageMapperMethod.java:261) ~[mybatis-plus-co
mybatisplus报Invalid bound statement (not found)错误的解决方法
09-07
搭建项目时使用了mybatisplus，项目能够正常启动，但在调用mapper方法查询数据库时报Invalid bound statement (not found)错误。本文给大家分享解决方案，感兴趣的朋友跟随小编一起看看吧
at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>错误
热门推荐
Attacked_code的博客
10-13 1万+
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.mybatis.mapper.OrdersMapper.finarray at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMetho...
org.apache.ibatis.binding.BindingException: Mapper method ‘cn.lexed.dao.BookMapper
weixin_62292469的博客
07-24 215
控制台报错： org.apache.ibatis.binding.BindingException: Mappermethod'cn.lexed.dao.BookMapper.updateBookInfoById'hasanunsupportedreturntype:classcn.lexed.pojo.BookInfo
spring boot | mapper.xml 报错：You have an error in your SQL syntax； check the manual that corresponds
xi
05-23 1016
mapper.xml 报错：You have an error in your SQL syntax; check the manual that corresponds
org.apache.ibatis.binding.BindingException: Mapper method 'attempted to return null
陈延伟
12-25 5802
org.apache.ibatis.binding.BindingException: Mapper method 'attempted to return null from a method with a primitive return type (long). 一、问题描述 今天发现测试环境报出来一个数据库相关的错误 org.apache.ibatis.binding.BindingE...
org.apache.ibatis.binding.BindingException:( Mapper method has an unsupported return type)
weixin_63833698的博客
03-04 220
做框架时候，遇到了这个错误，我一直以为是sql语句写错了，没想到不是 把Customer改成void，运行成功
SpringBoot中Mapper方法绑定出错/org.apache.ibatis.binding.BindException:Invalid bound statement(not found)解决
花花的小脑瓜的博客
04-25 1109
SpringBoot中Mapper方法绑定出错时怎么解决方案 1.背景 前几天在写SpringBoot项目，由于用的是最简单的增删改查，而且是最基本的controller调service层，service调mapper层，然后有映射文件mapper.xml就没有写一个测试一个，最后写完了才测试。就突然报错如图错误： 2.问题分析 报错信息大概就是说controller层调service接口时，service中的Mapper方法在mapper.xml中找不到对应的方法，也就是所说的没有绑定上。知道报错信息了就
[Bug]使用Mapper动态代理中出现org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):
weixin_44306038的博客
01-01 2040
1、具体提示信息 org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.itheima.mybatis.mapper.UserMapper.queryUserById at org.apache.ibatis.binding.MapperMethod$SqlCommand.&lt;...
多数据源使用mybatis-plus报错:org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)
最新发布
m0_50163856的博客
05-04 371
【代码】多数据源使用mybatis-plus报错:org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)
Spring报错：org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)
萧頔
03-10 3190
一、背景 最近在写个人项目的时候，出现了org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)这个错误。尝试了很多解决方法，终于解决了这个错误。在这里总结一下，以便查阅。 二、可能的原因： 1. mapper中namespace跟接口不对应可能导致的错误 2. springboot中...
报错：org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): xxx
AirDean的博客
11-03 926
【采坑日记】Mybatis中xml扫描问题 报错原文 "C:\Program Files\Java\jdk1.8.0_121\bin\java.exe" -XX:TieredStopAtLevel=1 -noverify -Dspring.output.ansi.enabled=always -Dcom.sun.management.jmxremote -Dspring.jmx.enabled=true -Dspring.liveBeansView.mbeanDomain -Dspring.applicat
org.apache.ibatis.binding.BindingException: Parameter 'username' not found. Available parameters
datouniao1的博客
01-26 2632
错误信息:  ### Error updating database. Cause: org.apache.ibatis.binding.BindingException: Parameter 'username' not found. Available parameters are [1, 2, param3, rowguid, param1, param2] ### The error...
org.apache.ibatis.binding.BindingException: Mapper method 'attempted to return null from a method wi...
anhe1364的博客
05-04 953
一、问题描述 今天发现测试环境报出来一个数据库相关的错误org.apache.ibatis.binding.BindingException: Mapper method 'attempted to return null from a method with a primitive return type (long). 二、问题根源 经过查询后发现，Mybatis 在查询id...
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): xx.xx.xx.xxMapper.x
m0_64284147的博客
11-22 1228
1、报错信息 org.apache.ibatis.binding.BindingException: Invalid bound statement (not found):com.ken.shoopingboot.mapper.RoleMapper.findTotal 看最上面那行，能最快，最准确的定位出错误的地方 at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init&g
Mybatis源码学习(15)-binding模块之MapperMethod类
向心行者
10-18 598
一、概述 1、Mybatis操作数据   在Mybatis中，进行数据操作时，有两种方式，分别是：1、使用传统的MyBatis提供的API；2、使用Mapper接口，即面向接口编程。 传统的Mybatis工作模式 示例： @Test public void testApi() { SqlSession sqlSession = mySqlSessionFactory.openSe...
idea的mapper.xml文件里写sql语句出现Tag name expected错误提示
a14654的博客
06-02 994
原因是：xml文件的某些特殊字符是自动转义的, xml解析器会忽视CDATA中的内容
整合SSM遇到问题（二）：Mybatis加载不到Mapper.xml文件问题
12-06 1628
整合SSM时，访问接口时报错：意思是，根据UserMapper.java 没有找到对应的UserMapper.xml文件 exception org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.binding....
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值