Invalid bound statement (not found)错误【已解决】

Invalid bound statement (not found)错误【已解决】

文章目录

• • @ 项目地址
  • @ 异常
  • @ 原因
  • @ 常规解决办法

@ 项目地址

开源地址：

@ 异常

21:18:32.741 [http-nio-8080-exec-4] ERROR c.j.l.GlobalExceptionHandler - [handleRuntimeException,70] - 请求地址'/tool/gen/list',发生未知异常.
org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.ator.mapper.GenTableMapper.selectGenTableListat org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235)at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:53)at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:108)at urrent.ConcurrentHashMapputeIfAbsent(ConcurrentHashMap.java:1660)at org.apache.ibatis.util.MapUtilputeIfAbsent(MapUtil.java:35)at org.apache.ibatis.binding.MapperProxy.cachedInvoker(MapperProxy.java:95)at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)at com.sun.proxy.$Proxy160.selectGenTableList(Unknown Source)at com.ator.service.GenTableServiceImpl.selectGenTableList(GenTableServiceImpl.java:97)at com.ator.service.GenTableServiceImpl$$FastClassBySpringCGLIB$$d00805f5.invoke(<generated>)at lib.proxy.MethodProxy.invoke(MethodProxy.java:218)at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)at com.ator.service.GenTableServiceImpl$$EnhancerBySpringCGLIB$$a642bd88.selectGenTableList(<generated>)at com.List(GenController.java:51)at com.ller.GenController$$FastClassBySpringCGLIB$$453a25e3.invoke(<generated>)at lib.proxy.MethodProxy.invoke(MethodProxy.java:218)at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)at org.springframework.security.access.intercept.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:61)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753)at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698)at com.ller.GenController$$EnhancerBySpringCGLIB$$List(<generated>)flect.NativeMethodAccessorImpl.invoke0(Native Method)flect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)flect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)at flect.Method.invoke(Method.java:498)at org.hod.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)at org.hod.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150)at org.springframework.web.hod.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117)at org.springframework.web.hod.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)at org.springframework.web.hod.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808)at org.springframework.web.hod.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067)at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963)at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)at javax.servlet.http.HttpServlet.service(HttpServlet.java:655)at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)at javax.servlet.http.HttpServlet.service(HttpServlet.java:764)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at at.websocket.server.WsFilter.doFilter(WsFilter.java:53)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at com.javapub.liawanmon.filter.RepeatableFilter.doFilter(RepeatableFilter.java:35)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:327)at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:115)at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:81)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:121)at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:115)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:126)at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:81)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:105)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:149)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at com.javapub.liawan.framework.security.filter.JwtAuthenticationTokenFilter.doFilterInternal(JwtAuthenticationTokenFilter.java:45)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:111)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:103)at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:89)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.security.web.header.HeaderWriterFilter.doHeadersAfter(HeaderWriterFilter.java:90)at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:75)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.t.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:110)at org.springframework.t.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:80)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.t.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:55)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:336)at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:211)at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:183)at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:354)at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:267)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at com.javapub.liawanmon.filter.XssFilter.doFilter(XssFilter.java:45)at org.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)at org.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)at org.StandardWrapperValve.invoke(StandardWrapperValve.java:197)at org.StandardContextValve.invoke(StandardContextValve.java:97)at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)at org.StandardHostValve.invoke(StandardHostValve.java:135)at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)at org.StandardEngineValve.invoke(StandardEngineValve.java:78)at org.tor.CoyoteAdapter.service(CoyoteAdapter.java:360)at http11.Http11Processor.service(Http11Processor.java:399)at AbstractProcessorLight.process(AbstractProcessorLight.java:65)at AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)at at.util.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)at at.util.SocketProcessorBase.run(SocketProcessorBase.java:49)at at.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)at at.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)at at.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)at java.lang.Thread.run(Thread.java:748)
21:18:32.750 [http-nio-8080-exec-4] WARN  o.s.a.ExceptionHandlerExceptionResolver - [logException,208] - Resolved [org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.ator.mapper.GenTableMapper.selectGenTableList]

@ 原因

所以，这里要改为这个路径。

@ 常规解决办法

四个常规解决办法，跑不了

其实出现这个问题实质就是mapper接口和l文件没有映射起来。
常见的错误如下：

1. 这个问题其实很好解决，瞪大眼睛，仔仔细细看看，到底对不对应不就好了嘛

2. mapper接口中的方法名和l中的id标签不一致
   这个问题和上个问题解决方法一样，仔细对对嘛，这个再对不出来，面壁思过吧。

3. 上两步的问题都没有，但是还是不行，可能原因就是，没有构建进去，打开target看看对应的l文件在不在

如果不在的话，clean一下，maven项目，然后再启动。

        <!-- 如果不添加此节点mybatis的l文件都会被漏掉。 --><resources><resource><directory>src/main/java</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>false</filtering></resource><resource><directory>src/main/resources</directory><includes><include>**/*.properties</include><include>**/*.xml</include></includes><filtering>false</filtering></resource></resources>