当前位置: 首页 > 编程笔记 >

MybatisPlus BaseMapper 中的方法全部 Invalid bound statement (not found Error处理)

端木望
2023-03-14
本文向大家介绍MybatisPlus BaseMapper 中的方法全部 Invalid bound statement (not found Error处理),包括了MybatisPlus BaseMapper 中的方法全部 Invalid bound statement (not found Error处理)的使用技巧和注意事项,需要的朋友参考一下

错误梗概

接手了一个新任务,需要修改别人的代码。看看数据库配置 ,连连接池都没,然后引入了 druid,本来一切很顺利。后来不知道怎么回事,运行起来后总是报 “Invalid bound statement (not found) ”,而且报错的都是 MybatisPlus 生成的 BaseMapper 中的方法,自己写的都能正常运行。

参考了很多其他帖子,都无果,最后弄了很久,终于搞定了,特级录之。

druid 和 mybatis-plus 配置参数如下:

pom.xml

<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid-spring-boot-starter</artifactId>
  <version>1.1.10</version>
 </dependency>

 <dependency>
  <groupId>com.baomidou</groupId>
  <artifactId>mybatis-plus-boot-starter</artifactId>
  <version>3.2.0</version>
 </dependency>

 <dependency>
  <groupId>com.github.pagehelper</groupId>
  <artifactId>pagehelper-spring-boot-starter</artifactId>
  <version>1.2.13</version>
  <exclusions>
  <exclusion>
   <artifactId>jsqlparser</artifactId>
   <groupId>com.github.jsqlparser</groupId>
  </exclusion>
  <exclusion>
   <artifactId>mybatis-spring</artifactId>
   <groupId>org.mybatis</groupId>
  </exclusion>
  </exclusions>
 </dependency>

application.properties

######################################################### MybatisPlus 配置
mybatis-plus.mapper-locations=classpath:mapper/*.xml
mybatis-plus.type-aliases-package=com.yishi.entity
mybatis-plus.global-config.db-config.table-underline=true
mybatis-plus.global-config.banner=false
mybatis-plus.configuration.map-underscore-to-camel-case=true
mybatis-plus.configuration.jdbc-type-for-null=NULL
mybatis-plus.configuration.auto-mapping-behavior=FULL
######################################################### druid 配置
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
# 参考 https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter
#################################### JDBC 配置
spring.datasource.druid.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.druid.url=${mysql.url}
spring.datasource.druid.username=${mysql.username}
spring.datasource.druid.password=${mysql.password}
#################################### 连接池配置
# 初始化大小,最小,最大
spring.datasource.druid.initial-size=10
spring.datasource.druid.max-active=500
spring.datasource.druid.min-idle=5
# 配置获取连接等待超时的时间
spring.datasource.druid.max-wait=60000
# 打开PSCache,并且指定每个连接上PSCache的大小
spring.datasource.druid.pool-prepared-statements=true
spring.datasource.druid.max-pool-prepared-statement-per-connection-size=20
#spring.datasource.druid.max-open-prepared-statements= #和上面的等价
#spring.datasource.druid.validation-query=
#spring.datasource.druid.validation-query-timeout=
spring.datasource.druid.test-on-borrow=false
spring.datasource.druid.test-on-return=false
spring.datasource.druid.test-while-idle=true
# 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
spring.datasource.druid.time-between-eviction-runs-millis=60000
# 配置一个连接在池中最小生存的时间,单位是毫秒
spring.datasource.druid.min-evictable-idle-time-millis=300000
#spring.datasource.druid.max-evictable-idle-time-millis=
# 配置监控统计拦截的filters,去掉后监控界面sql无法统计,'wall'用于防火墙
spring.datasource.druid.filters=stat,wall,log4j
spring.datasource.druid.validation-query=SELECT 1 FROM DUAL
# 通过connectProperties属性来打开mergeSql功能;慢SQL记录
spring.datasource.druid.connectionProperties=druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000
#################################### 监控配置
# WebStatFilter配置,说明请参考Druid Wiki,配置_配置WebStatFilter
spring.datasource.druid.web-stat-filter.enabled=true
spring.datasource.druid.web-stat-filter.url-pattern=/*
spring.datasource.druid.web-stat-filter.exclusions=/druid/*,*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico
spring.datasource.druid.web-stat-filter.session-stat-enable=true
spring.datasource.druid.web-stat-filter.session-stat-max-count=10
#spring.datasource.druid.web-stat-filter.principal-session-name=
#spring.datasource.druid.web-stat-filter.principal-cookie-name=
#spring.datasource.druid.web-stat-filter.profile-enable=
# StatViewServlet配置,说明请参考Druid Wiki,配置_StatViewServlet配置
spring.datasource.druid.stat-view-servlet.enabled=true
spring.datasource.druid.stat-view-servlet.url-pattern=/druid/*
spring.datasource.druid.stat-view-servlet.reset-enable=true
spring.datasource.druid.stat-view-servlet.login-username=admin
spring.datasource.druid.stat-view-servlet.login-password=admin
#spring.datasource.druid.stat-view-servlet.allow=
#spring.datasource.druid.stat-view-servlet.deny=

DruidDataSourceProperties

package com.yishi.config;

import org.springframework.boot.context.properties.ConfigurationProperties;

@ConfigurationProperties(prefix = "spring.datasource.druid")
public class DruidDataSourceProperties {
 private String driverClassName;
 private String url;
 private String username;
 private String password;

 private int initialSize;
 private int minIdle;
 private int maxActive;
 private long maxWait;
 private long timeBetweenEvictionRunsMillis;
 private long minEvictableIdleTimeMillis;
 private String validationQuery;
 private boolean testWhileIdle;
 private boolean testOnBorrow;
 private boolean testOnReturn;
 private boolean poolPreparedStatements;
 private int maxPoolPreparedStatementPerConnectionSize;
 private String filters;
 private String connectionProperties;

 // 省略 get、set 方法
}

MysqlDruidConfiguration

package com.yishi.config;

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.EnableConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

import javax.sql.DataSource;
import java.sql.SQLException;

@Configuration
@EnableConfigurationProperties({DruidDataSourceProperties.class})
@MapperScan(value = MysqlDruidConfiguration.PACKAGE, sqlSessionFactoryRef = "mysqlSqlSessionFactory")
public class MysqlDruidConfiguration {

 static final String PACKAGE = "com.yishi.dao";

 static final String MAPPER_LOCATION = "classpath:mapper/*.xml";

 @Autowired
 private DruidDataSourceProperties properties;

 @Bean(name = "mysqlDataSource")
 @Primary
 public DataSource mysqlDataSource() {
 DruidDataSource druidDataSource = new DruidDataSource();
 druidDataSource.setDriverClassName(properties.getDriverClassName());
 druidDataSource.setUrl(properties.getUrl());
 druidDataSource.setUsername(properties.getUsername());
 druidDataSource.setPassword(properties.getPassword());
 druidDataSource.setInitialSize(properties.getInitialSize());
 druidDataSource.setMinIdle(properties.getMinIdle());
 druidDataSource.setMaxActive(properties.getMaxActive());
 druidDataSource.setMaxWait(properties.getMaxWait());
 druidDataSource.setTimeBetweenEvictionRunsMillis(properties.getTimeBetweenEvictionRunsMillis());
 druidDataSource.setMinEvictableIdleTimeMillis(properties.getMinEvictableIdleTimeMillis());
 druidDataSource.setValidationQuery(properties.getValidationQuery());
 druidDataSource.setTestWhileIdle(properties.isTestWhileIdle());
 druidDataSource.setTestOnBorrow(properties.isTestOnBorrow());
 druidDataSource.setTestOnReturn(properties.isTestOnReturn());
 druidDataSource.setPoolPreparedStatements(properties.isPoolPreparedStatements());
 druidDataSource.setMaxPoolPreparedStatementPerConnectionSize(properties.getMaxPoolPreparedStatementPerConnectionSize());
 druidDataSource.setConnectionProperties(properties.getConnectionProperties());
 try {
  druidDataSource.setFilters(properties.getFilters());
  druidDataSource.init();
 } catch (SQLException e) {
  e.printStackTrace();
 }

 return druidDataSource;
 }

 @Bean(name = "mysqlTransactionManager")
 @Primary
 public DataSourceTransactionManager mysqlTransactionManager() {
 return new DataSourceTransactionManager(mysqlDataSource());
 }

 @Bean(name = "mysqlSqlSessionFactory")
 @Primary
 public SqlSessionFactory mysqlSqlSessionFactory(@Qualifier("mysqlDataSource") DataSource mysqlDataSource)
  throws Exception {
 final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
 sessionFactory.setDataSource(mysqlDataSource);
 sessionFactory.setMapperLocations(
  new PathMatchingResourcePatternResolver().getResources(MysqlDruidConfiguration.MAPPER_LOCATION));
 return sessionFactory.getObject();
 }

 @Bean(name = "mysqlJdbcTemplate")
 public JdbcTemplate hiveJdbcTemplate(@Qualifier("mysqlDataSource") DataSource dataSource) {
 return new JdbcTemplate(dataSource);
 }
}

开发环境

IDEA 2020.2
Apache Maven 3.2.5
主要库版本:
org.springframework.boot.spring-boot-dependencies.2.1.1.RELEASE
com.baomidou.mybatis-plus-boot-starter.3.2.0
com.alibaba.druid-spring-boot-starter.1.1.10

异常信息

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.yishi.dao.UserDao.selectList
	at 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$cachedMapperMethod$0(MapperProxy.java:98)
	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)
	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:97)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:92)
	at com.sun.proxy.$Proxy105.selectList(Unknown Source)
	at com.yishi.impl.UserServiceImpl.insert(UserServiceImpl.java:104)
	at com.yishi.impl.UserServiceImpl.insert(UserServiceImpl.java:39)
	at com.yishi.impl.UserServiceImpl$$FastClassBySpringCGLIB$$ac0e5ea9.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.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:294)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
	at com.yishi.impl.UserServiceImpl$$EnhancerBySpringCGLIB$$c9a67874.insert(<generated>)
	at com.yishi.controller.UserController.add(UserController.java:20)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	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:660)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	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:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:791)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1417)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	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)

解决方式

一开始没打开 Debug 日志,导致很多 Debug 的信息都没法及时捕获,打开 Debug 日志后,WARN 如下:

2020-09-01 10:02:15 [restartedMain] WARN  o.m.s.m.ClassPathMapperScanner - Skipping MapperFactoryBean with name 'userDao' and 'com.yishi.dao.UserDao' mapperInterface. Bean already defined with the same name!

...

2020-09-01 10:02:15 [restartedMain] WARN  o.m.s.m.ClassPathMapperScanner - No MyBatis mapper was found in '[com.yishi.dao]' package. Please check your configuration.

可以看到,在注入 dao 时说已经存在了,难怪 Mybatis-Plus 生成的 BaseMapper 所有方法报错,压根就没注入。那什么地方先注入了呢?看来看去,原来是在 MysqlDruidConfiguration.java 这个类在自动配置时配置 “mysqlSqlSessionFactory” 这个 bean 时已经先注入 dao 相关的信息!

最后解决方式,删掉 MysqlDruidConfiguration.java 和 DruidDataSourceProperties.java这两个类,springboot 都已经帮我们处理了 druid 的配置,其实这两个类也没什么用。

总结

到此这篇关于MybatisPlus BaseMapper 中的方法全部 Invalid bound statement (not found Error处理)的文章就介绍到这了,更多相关MybatisPlus BaseMapper内容请搜索小牛知识库以前的文章或继续浏览下面的相关文章希望大家以后多多支持小牛知识库!

 类似资料:
  • 我在尝试在Spring Boot应用程序中启用全局方法安全性时遇到了一些问题。或多或少我有这样的配置: @Secure注释在服务中工作正常,但在控制器中不行,所以我读到这里(http://docs.spring.io/spring-security/site/faq/faq.html#faq-method-security-in-web-context)我认为这是因为方法安全性只在根应用程序上下文

  • 问题内容: 我有一个关于可变范围的问题。 例如: 现在,我创建两个线程,并为每个线程创建一个实例。 当我在每个线程中调用时,可以保证线程安全吗? 本地变量存储在哪里?每个线程的堆栈?堆空间? PS我知道在这种情况下,静态是毫无意义的。我在我们的旧代码中找到了它;我只是想确定我所知道的! 问题答案: 局部变量存储在每个线程自己的堆栈中。这意味着局部变量永远不会在线程之间共享。这也意味着所有本地原始变

  • 我在用流星做一个消息应用程序。出于安全原因,我禁用了从客户端调用的任何插入/更新/删除。现在插入消息的唯一方法是使用方法。 如果是这种情况,我将不得不在函数上包含额外的参数,这将使它更加不安全。 我可能不明白这里的方法。

  • 本文向大家介绍Intellij IDEA 热部署处理方法(图解),包括了Intellij IDEA 热部署处理方法(图解)的使用技巧和注意事项,需要的朋友参考一下 1. 首先参考IDEA热部署同行经验分享: Intellij IDEA 4种配置热部署的方法 2. IDEA 热部署实战: springboot项目: 不要引入热部署工具包spring-boot-devtools 在Intellij I

  • 我在MonoForAndroid中有一个活动,它利用Zaxy. Net. Mobile在Android上扫描条形码。就扫描和返回结果而言,一切都很好。但是,当我尝试处理scanOverlie上的任何事件时,我得到nullRe的异常。我的代码在下面,任何帮助都将不胜感激。 上面的所有代码都工作正常。但是,当我尝试处理布局上的完成按钮时,我得到了NullRe的异常 下面是例外的详细信息

  • 问题内容: 我使用Node-Mongo-Native并尝试设置全局连接变量,但是我对两种可能的解决方案感到困惑。你们可以帮我选哪一个是好人吗?1.解决方案(这很糟糕,因为每个请求都将尝试创建新的连接。) 解决方案(在应用程序初始化时进行连接并将连接字符串分配给全局变量)。但我认为将连接字符串分配给全局变量不是一个好主意。 var mongodb; var url =’[connectionStri