在Spring-Boot中配置mybatis多数据源

最新推荐文章于 2023-04-12 15:37:09 发布
最新推荐文章于 2023-04-12 15:37:09 发布
阅读量84 收藏
点赞数
文章标签： java 数据库 python
原文链接：https://my.oschina.net/bfleeee/blog/889128
版权

2019独角兽企业重金招聘Python工程师标准>>> hot3.png

来不及了，直接上代码:D

@Configuration
@EnableConfigurationProperties(DatabaseConfigProperties.class)
@EnableTransactionManagement
public class DatabaseConfig {
    @Autowired
    DatabaseConfigProperties config ;

    @Bean(name="dataSource", initMethod="init",destroyMethod="close")
    @Primary // http://docs.spring.io/spring-boot/docs/current/reference/htmlsingle/#howto-two-datasources ，否则spring-boot的DataSourceInitializer在进行数据源初始化时会抛出异常
    public DataSource dataSource(){
        DruidDataSource ds = new DruidDataSource();
        ds.setUrl(config.getUrl());
        ds.setUsername(config.getUsername());
        ds.setPassword(config.getPassword());
        ds.setInitialSize(ds.getInitialSize());
        ds.setMinIdle(config.getMinIdle());
        ds.setMaxActive(config.getMaxActive());
        ds.setMaxWait(config.getMaxWait());
        ds.setTimeBetweenEvictionRunsMillis(config.getTimeBetweenEvictionRunsMillis()); // 关闭检测间隔 毫秒
        ds.setMinEvictableIdleTimeMillis(config.getMinEvictableIdleTimeMillis()); // 一个连接的最小生存时间
        ds.setValidationQuery("SELECT 'x'");
        ds.setTestWhileIdle(config.isTestWhileIdle());
        ds.setTestOnBorrow(config.isTestOnBorrow());
        ds.setTestOnReturn(config.isTestOnReturn());
        ds.setPoolPreparedStatements(config.isPoolPreparedStatements());
        ds.setMaxPoolPreparedStatementPerConnectionSize(config.getMaxPoolPreparedStatementPerConnectionSize());
        ds.setRemoveAbandoned(config.isRemoveAbandoned());
        ds.setRemoveAbandonedTimeout(config.getRemoveAbandonedTimeout());
        ds.setLogAbandoned(config.isLogAbandoned());
        ds.setTimeBetweenLogStatsMillis(config.getTimeBetweenLogStatsMillis());
        ds.setPhyTimeoutMillis(config.getPhyTimeoutMillis());
        ds.setMaxEvictableIdleTimeMillis(config.getMaxEvictableIdleTimeMillis());
        ds.setDbType("mysql");
        try {
            ds.setFilters("stat,slf4j");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return ds ;
    }

    @Bean
    public Interceptor[] interceptors(){
        return new Interceptor[]{
            new MybatisInterceptor(),
        };
    }
    @Bean(name="sqlSessionFactory")
    public SqlSessionFactory sqlSessionFactory() throws Exception {
        final SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setDataSource(dataSource());
        factoryBean.setPlugins(interceptors());
        return factoryBean.getObject();
    }


    @Bean(name="transactionManager")
    PlatformTransactionManager transactionManager(){
        DataSourceTransactionManager transactionManager = new DataSourceTransactionManager(dataSource());
        return transactionManager;
    }

    @Bean
    DaoAspect daoAspect(){
      return new DaoAspect();
    }

    @Configuration
    @MapperScan(basePackages="nam.doog.test.dao.mapper", sqlSessionFactoryRef = "sqlSessionFactory")
    public static class MapperConfig{
      // 不能和外部类放在一起配置，否则会导致Mapper找不到正确的sqlSessionFactory
    }
}

@ConfigurationProperties(
    prefix = "jdbc",
    ignoreUnknownFields = false)
public class DatabaseConfigProperties {

  private String url,
      username,
      password,
      validationQuery = "SELECT 'x";
  private int initialSize,
      minIdle,
      maxActive,
      maxWait,
      maxPoolPreparedStatementPerConnectionSize,
      removeAbandonedTimeout;

  private long timeBetweenEvictionRunsMillis,
      minEvictableIdleTimeMillis,
      timeBetweenLogStatsMillis,
      phyTimeoutMillis,
      maxEvictableIdleTimeMillis;

  private boolean testWhileIdle,
      testOnBorrow,
      testOnReturn,
      poolPreparedStatements,
      removeAbandoned,
      logAbandoned;

  public String getUrl() {
    return url;
  }

  public void setUrl(String url) {
    this.url = url;
  }

  public String getUsername() {
    return username;
  }

  public void setUsername(String username) {
    this.username = username;
  }

  public String getPassword() {
    return password;
  }

  public void setPassword(String password) {
    this.password = password;
  }

  public String getValidationQuery() {
    return validationQuery;
  }

  public void setValidationQuery(String validationQuery) {
    this.validationQuery = validationQuery;
  }

  public int getInitialSize() {
    return initialSize;
  }

  public void setInitialSize(int initialSize) {
    this.initialSize = initialSize;
  }

  public int getMinIdle() {
    return minIdle;
  }

  public void setMinIdle(int minIdle) {
    this.minIdle = minIdle;
  }

  public int getMaxActive() {
    return maxActive;
  }

  public void setMaxActive(int maxActive) {
    this.maxActive = maxActive;
  }

  public int getMaxWait() {
    return maxWait;
  }

  public void setMaxWait(int maxWait) {
    this.maxWait = maxWait;
  }

  public int getMaxPoolPreparedStatementPerConnectionSize() {
    return maxPoolPreparedStatementPerConnectionSize;
  }

  public void setMaxPoolPreparedStatementPerConnectionSize(
      int maxPoolPreparedStatementPerConnectionSize) {
    this.maxPoolPreparedStatementPerConnectionSize = maxPoolPreparedStatementPerConnectionSize;
  }

  public int getRemoveAbandonedTimeout() {
    return removeAbandonedTimeout;
  }

  public void setRemoveAbandonedTimeout(int removeAbandonedTimeout) {
    this.removeAbandonedTimeout = removeAbandonedTimeout;
  }

  public long getTimeBetweenEvictionRunsMillis() {
    return timeBetweenEvictionRunsMillis;
  }

  public void setTimeBetweenEvictionRunsMillis(long timeBetweenEvictionRunsMillis) {
    this.timeBetweenEvictionRunsMillis = timeBetweenEvictionRunsMillis;
  }

  public long getMinEvictableIdleTimeMillis() {
    return minEvictableIdleTimeMillis;
  }

  public void setMinEvictableIdleTimeMillis(long minEvictableIdleTimeMillis) {
    this.minEvictableIdleTimeMillis = minEvictableIdleTimeMillis;
  }

  public long getTimeBetweenLogStatsMillis() {
    return timeBetweenLogStatsMillis;
  }

  public void setTimeBetweenLogStatsMillis(long timeBetweenLogStatsMillis) {
    this.timeBetweenLogStatsMillis = timeBetweenLogStatsMillis;
  }

  public long getPhyTimeoutMillis() {
    return phyTimeoutMillis;
  }

  public void setPhyTimeoutMillis(long phyTimeoutMillis) {
    this.phyTimeoutMillis = phyTimeoutMillis;
  }

  public long getMaxEvictableIdleTimeMillis() {
    return maxEvictableIdleTimeMillis;
  }

  public void setMaxEvictableIdleTimeMillis(long maxEvictableIdleTimeMillis) {
    this.maxEvictableIdleTimeMillis = maxEvictableIdleTimeMillis;
  }

  public boolean isTestWhileIdle() {
    return testWhileIdle;
  }

  public void setTestWhileIdle(boolean testWhileIdle) {
    this.testWhileIdle = testWhileIdle;
  }

  public boolean isTestOnBorrow() {
    return testOnBorrow;
  }

  public void setTestOnBorrow(boolean testOnBorrow) {
    this.testOnBorrow = testOnBorrow;
  }

  public boolean isTestOnReturn() {
    return testOnReturn;
  }

  public void setTestOnReturn(boolean testOnReturn) {
    this.testOnReturn = testOnReturn;
  }

  public boolean isPoolPreparedStatements() {
    return poolPreparedStatements;
  }

  public void setPoolPreparedStatements(boolean poolPreparedStatements) {
    this.poolPreparedStatements = poolPreparedStatements;
  }

  public boolean isRemoveAbandoned() {
    return removeAbandoned;
  }

  public void setRemoveAbandoned(boolean removeAbandoned) {
    this.removeAbandoned = removeAbandoned;
  }

  public boolean isLogAbandoned() {
    return logAbandoned;
  }

  public void setLogAbandoned(boolean logAbandoned) {
    this.logAbandoned = logAbandoned;
  }

}

@Configuration
@EnableConfigurationProperties(AnotherDatabaseConfigProperties.class)
public class AnotherDatabaseConfig { // 因为不需要事务，所以没有写事务配置，有需要可以加上
    @Autowired
    AnotherDatabaseConfigProperties config ;

    @Bean(name="anotherDataSource", initMethod="init",destroyMethod="close" )
    public DataSource anotherDataSource(){
        DruidDataSource ds = new DruidDataSource();
        ds.setUrl(config.getUrl());
        ds.setUsername(config.getUsername());
        ds.setPassword(config.getPassword());
        ds.setInitialSize(ds.getInitialSize());
        ds.setMinIdle(config.getMinIdle());
        ds.setMaxActive(config.getMaxActive());
        ds.setMaxWait(config.getMaxWait());
        ds.setTimeBetweenEvictionRunsMillis(config.getTimeBetweenEvictionRunsMillis()); // 关闭检测间隔 毫秒
        ds.setMinEvictableIdleTimeMillis(config.getMinEvictableIdleTimeMillis()); // 一个连接的最小生存时间
        ds.setValidationQuery("SELECT 'x'");
        ds.setTestWhileIdle(config.isTestWhileIdle());
        ds.setTestOnBorrow(config.isTestOnBorrow());
        ds.setTestOnReturn(config.isTestOnReturn());
        ds.setPoolPreparedStatements(config.isPoolPreparedStatements());
        ds.setMaxPoolPreparedStatementPerConnectionSize(config.getMaxPoolPreparedStatementPerConnectionSize());
        ds.setRemoveAbandoned(config.isRemoveAbandoned());
        ds.setRemoveAbandonedTimeout(config.getRemoveAbandonedTimeout());
        ds.setLogAbandoned(config.isLogAbandoned());
        ds.setTimeBetweenLogStatsMillis(config.getTimeBetweenLogStatsMillis());
        ds.setPhyTimeoutMillis(config.getPhyTimeoutMillis());
        ds.setMaxEvictableIdleTimeMillis(config.getMaxEvictableIdleTimeMillis());
        ds.setDbType("mysql");
        try {
            ds.setFilters("stat,slf4j");
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return ds ;
    }

    @Bean(name="anotherSqlSessionFactory")
    public SqlSessionFactory sqlSessionFactory() throws Exception {
        final SqlSessionFactoryBean factoryBean = new SqlSessionFactoryBean();
        factoryBean.setDataSource(anotherDataSource());
        return factoryBean.getObject();
    }

    @Configuration
    @MapperScan(basePackages="nam.doog.test.dao.anothermapper", sqlSessionFactoryRef = "anotherSqlSessionFactory")
    public static class MapperConfig{

    }
}

@ConfigurationProperties(
    prefix = "anotherjdbc",
    ignoreUnknownFields = false)
public class AnotherPayDatabaseConfigProperties {

  private String url,
      username,
      password,
      validationQuery = "SELECT 'x";
  private int initialSize,
      minIdle,
      maxActive,
      maxWait,
      maxPoolPreparedStatementPerConnectionSize,
      removeAbandonedTimeout;

  private long timeBetweenEvictionRunsMillis,
      minEvictableIdleTimeMillis,
      timeBetweenLogStatsMillis,
      phyTimeoutMillis,
      maxEvictableIdleTimeMillis;

  private boolean testWhileIdle,
      testOnBorrow,
      testOnReturn,
      poolPreparedStatements,
      removeAbandoned,
      logAbandoned;

  public String getUrl() {
    return url;
  }

  public void setUrl(String url) {
    this.url = url;
  }

  public String getUsername() {
    return username;
  }

  public void setUsername(String username) {
    this.username = username;
  }

  public String getPassword() {
    return password;
  }

  public void setPassword(String password) {
    this.password = password;
  }

  public String getValidationQuery() {
    return validationQuery;
  }

  public void setValidationQuery(String validationQuery) {
    this.validationQuery = validationQuery;
  }

  public int getInitialSize() {
    return initialSize;
  }

  public void setInitialSize(int initialSize) {
    this.initialSize = initialSize;
  }

  public int getMinIdle() {
    return minIdle;
  }

  public void setMinIdle(int minIdle) {
    this.minIdle = minIdle;
  }

  public int getMaxActive() {
    return maxActive;
  }

  public void setMaxActive(int maxActive) {
    this.maxActive = maxActive;
  }

  public int getMaxWait() {
    return maxWait;
  }

  public void setMaxWait(int maxWait) {
    this.maxWait = maxWait;
  }

  public int getMaxPoolPreparedStatementPerConnectionSize() {
    return maxPoolPreparedStatementPerConnectionSize;
  }

  public void setMaxPoolPreparedStatementPerConnectionSize(
      int maxPoolPreparedStatementPerConnectionSize) {
    this.maxPoolPreparedStatementPerConnectionSize = maxPoolPreparedStatementPerConnectionSize;
  }

  public int getRemoveAbandonedTimeout() {
    return removeAbandonedTimeout;
  }

  public void setRemoveAbandonedTimeout(int removeAbandonedTimeout) {
    this.removeAbandonedTimeout = removeAbandonedTimeout;
  }

  public long getTimeBetweenEvictionRunsMillis() {
    return timeBetweenEvictionRunsMillis;
  }

  public void setTimeBetweenEvictionRunsMillis(long timeBetweenEvictionRunsMillis) {
    this.timeBetweenEvictionRunsMillis = timeBetweenEvictionRunsMillis;
  }

  public long getMinEvictableIdleTimeMillis() {
    return minEvictableIdleTimeMillis;
  }

  public void setMinEvictableIdleTimeMillis(long minEvictableIdleTimeMillis) {
    this.minEvictableIdleTimeMillis = minEvictableIdleTimeMillis;
  }

  public long getTimeBetweenLogStatsMillis() {
    return timeBetweenLogStatsMillis;
  }

  public void setTimeBetweenLogStatsMillis(long timeBetweenLogStatsMillis) {
    this.timeBetweenLogStatsMillis = timeBetweenLogStatsMillis;
  }

  public long getPhyTimeoutMillis() {
    return phyTimeoutMillis;
  }

  public void setPhyTimeoutMillis(long phyTimeoutMillis) {
    this.phyTimeoutMillis = phyTimeoutMillis;
  }

  public long getMaxEvictableIdleTimeMillis() {
    return maxEvictableIdleTimeMillis;
  }

  public void setMaxEvictableIdleTimeMillis(long maxEvictableIdleTimeMillis) {
    this.maxEvictableIdleTimeMillis = maxEvictableIdleTimeMillis;
  }

  public boolean isTestWhileIdle() {
    return testWhileIdle;
  }

  public void setTestWhileIdle(boolean testWhileIdle) {
    this.testWhileIdle = testWhileIdle;
  }

  public boolean isTestOnBorrow() {
    return testOnBorrow;
  }

  public void setTestOnBorrow(boolean testOnBorrow) {
    this.testOnBorrow = testOnBorrow;
  }

  public boolean isTestOnReturn() {
    return testOnReturn;
  }

  public void setTestOnReturn(boolean testOnReturn) {
    this.testOnReturn = testOnReturn;
  }

  public boolean isPoolPreparedStatements() {
    return poolPreparedStatements;
  }

  public void setPoolPreparedStatements(boolean poolPreparedStatements) {
    this.poolPreparedStatements = poolPreparedStatements;
  }

  public boolean isRemoveAbandoned() {
    return removeAbandoned;
  }

  public void setRemoveAbandoned(boolean removeAbandoned) {
    this.removeAbandoned = removeAbandoned;
  }

  public boolean isLogAbandoned() {
    return logAbandoned;
  }

  public void setLogAbandoned(boolean logAbandoned) {
    this.logAbandoned = logAbandoned;
  }
}

application.yml:

jdbc:
  url: jdbc:mysql://xxxx/db1?useUnicode=true&characterEncoding=utf8&autoReconnect=true
  username: *****
  password: *****
  initialSize: 5
  minIdle: 10
  maxActive: 100
  maxWait: 60000

  timeBetweenEvictionRunsMillis: 10000
  minEvictableIdleTimeMillis: 40000
  testWhileIdle: true
  testOnBorrow: false
  testOnReturn: false
  poolPreparedStatements: false
  maxPoolPreparedStatementPerConnectionSize: 20
  removeAbandoned: true
  removeAbandonedTimeout: 180
  logAbandoned: true
  timeBetweenLogStatsMillis: 1800000
  phyTimeoutMillis: 100000
  maxEvictableIdleTimeMillis: 100000

anotherjdbc:
  url: jdbc:mysql://xxxx/db2?useUnicode=true&characterEncoding=utf8&autoReconnect=true
  username: *****
  password: *****
  initialSize: 5
  minIdle: 10
  maxActive: 100
  maxWait: 60000

  timeBetweenEvictionRunsMillis: 10000
  minEvictableIdleTimeMillis: 40000
  testWhileIdle: true
  testOnBorrow: false
  testOnReturn: false
  poolPreparedStatements: false
  maxPoolPreparedStatementPerConnectionSize: 20
  removeAbandoned: true
  removeAbandonedTimeout: 180
  logAbandoned: true
  timeBetweenLogStatsMillis: 1800000
  phyTimeoutMillis: 100000
  maxEvictableIdleTimeMillis: 100000

转载于:https://my.oschina.net/bfleeee/blog/889128

weixin_33922670
关注
mysql poolpreparedstatements_Java DruidDataSource.setPoolPreparedStatements方法代碼示例
weixin_30923925的博客
01-20 708
本文整理匯總了Java中com.alibaba.druid.pool.DruidDataSource.setPoolPreparedStatements方法的典型用法代碼示例。如果您正苦於以下問題：Java DruidDataSource.setPoolPreparedStatements方法的具體用法？Java DruidDataSource.setPoolPreparedStatements怎...
SpringBoot+Druid+Mybatis配置多数据源
hellojoy的博客
03-20 2825
https://blog.51cto.com/zero01/2161509 我们在开发一个项目的时候，可能会遇到需要对多个数据库进行读写的需求，这时候就得在项目中配置多个数据源了。在Java项目的开发中，目前最常用的数据操作框架是 Mybatis，开发框架也都基本用上了SpringBoot。而Druid号称最好的数据库连接池，自然也是被广泛使用。 所以本文将演示一下，SpringBoot+Dr...
Spring Boot下Druid连接池的使用配置分析
热门推荐
木小鱼的笔记
08-31 12万+
引言： 在Spring Boot下默认提供了若干种可用的连接池，Druid来自于阿里系的一个开源连接池，在连接池之外，还提供了非常优秀的监控功能，这里讲解如何与Spring Boot实现集成。 1.  环境描述      Spring Boot 1.4.0.RELEASE,  JDK 1.8 2.   Druid介绍      Druid是一个JDBC组件，它包括三部分：  DruidD...
SpringBoot 多数据源配置
Strange_boy的博客
04-12 515
*** 多数据源属性*/
druid作为数据库连接池的几种配置总结，通过debug去跟配置结果
神韵
08-08 1万+
整篇文章基于SpringBoot2.2.6编写。不同SpringBoot配置存在某些差异，后面会提。 默认的数据连接池 application.yml配置 spring: #数据源配置，使用默认的数据库连接池 datasource: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://localhost:3306/essm_dev?useUnicode=true&characterEncoding=u
spring-boot-starter-mybatis-spring-boot-1.0.2.zip
04-19
它包含了MyBatis、MyBatis-Spring以及相关的配置类，使开发者能够快速地在Spring Boot项目中使用MyBatis。"spring-boot-starter-mybatis-spring-boot-1.0.2"这个版本即为该起步依赖的一个特定版本，适用于Windows...
spring-boot-sample：spring-boot集成的druid数据库连接池，spring-boot实现的德鲁伊的动态数据源，spring-boot实现定时任务时间表，spring-boot集成mybatis
02-05
Spring Boot Druid Mybatis Schedule动态数据源JPA 本系列是spring-boot相关的一些列子，比如spring-boot集成druid，以及druid的动态数据源切换， spring-boot 集成mybatis，spring-boot集成定时器等等 1，弹簧靴...
spring-boot-starter-mybatis-spring-boot-1.1.0.zip
04-19
通过添加依赖、配置MyBatis、创建Mapper接口和XML文件、配置数据源和事务管理，我们就能在Spring Boot项目中愉快地使用MyBatis进行数据操作。在实际开发过程中，根据项目的具体需求，我们还可以进一步定制MyBatis的...
spring-boot-starter-mybatis-spring-boot-1.3.3.zip
04-19
Spring Boot会自动配置数据源，只需要在`application.properties`或`application.yml`中配置数据库的相关信息，如JDBC连接URL、用户名、密码等。 3. **配置MyBatis** 在`src/main/resources`下创建`mybatis-...
spring-boot-starter-mybatis-spring-boot-2.1.2.zip
最新发布
04-19
Spring Boot通过`@EnableAutoConfiguration`注解自动配置MyBatis，包括数据源、SqlSessionFactory、MapperScannerConfigurer等。其中，`mybatis-spring-boot-autoconfigure`模块中的`MybatisAutoConfiguration`类...
连接池优化之启用PoolPreparedStatements
coolmsn8786的博客
12-23 1132
DBCP连接池可以缓存PreparedStatement，本质上就是缓存游标。 一个SQL语句，无论是Insert,Update,Delete还是Select都是游标操作，只不过Select游标指向查询结果，而...
DruidCP源码阅读4 -- keepAlive保活机制
扬帆起航
05-13 5669
DruidCP源码阅读4 -- keepAlive保活机制
druid数据库连接池物理连接超时时间phyTimeoutMills及物理最大连接数phyMaxUseCount
OceanSky的专栏
02-26 8602
配置： #物理超时时间，默认：-1 spring.emily.datasource.config.mysql.phy-timeout-millis=-1 #物理最大连接数，默认：-1（不建议配置） spring.emily.datasource.config.mysql.phy-max-use-count=-1 phy-timeout-millis是指连接的最大物理连接时长，超过则会被强制回收，phy-max-use-count则是最大的物理连接数，超过则会被强制回收，这两个连接都要慎用； phy-t
Druid连接池超时连接清理配置排坑
xingor的博客
06-11 2万+
案发现场 在给某个陈旧项目的连接池组件替换成Druid，开开心心地用上了网上淘来的一份推荐配置，在本地运行了下没有问题便发布到环境上去试跑看下，随后大概是过了一杯咖啡的时间，环境上就出现了如下报错信息， [DEBUG][com.alibaba.druid.pool.DruidDataSource:1319][-][-] skip not validate connection. [DEBUG][com.alibaba.druid.util.JdbcUtils:75][-][-] close connecti
druid1.0.21版本源码研究之连接回收(分析解决mysql8小时断线)
Stand by
10-10 9001
首先我想说的是,翻遍百度没有一个可用的解决方案,呵呵..我相信实际解决的人不在少数... 大家众所周知,mysql和druid可谓数据库和数据库连接池中的佼佼者... 第一次用mysql用的还是比较头疼的... 尤其是同时碰上druid...简直是要命了.. 换过好几次druid版本,完全没有解决... github上看wenshao说的,maxEvictableIdleTimeMill
Spring Boot使用Druid和监控配置
weixin_33857679的博客
02-25 330
完美与Spring Boot集成。 1、编写Spring BootDruid配置类 DruidDataSourceProperties.java package org.paascloud.ops.config; import org.springframework.boot.context.properties.ConfigurationPro...
Spring Boot 集成 Druid
架构师的成长之路的博客
01-14 1万+
Spring Boot 集成 Druid更多干货spring-boot系列一 之restfull api与多环境配置springboot系列二之 日志SpringBoot系列三之 MVC 模版引擎SpringBoot 2.0.0.M7 系列四 异常处理springboot 2.0.0.M7之 注解 与 配置springboot 2.0.0.M7 配置mvcspringboot 2.0.0.M7 之...
关于MySql8小时空闲后连接超时问题（testOnBorrow，logAbandoned等）
lkforce
08-01 5926
程序和数据库之间的连接，8小时如果没有数据访问，MySQL会断开该连接。 如果使用的连接池，该断开操作不会通知连接池，造成连接池获取连接后无法连接数据库，报的异常大概是这样的： Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received fro
SQL state [null]; error code [0]; connection holder is null
蓝天之枫
01-16 1万+
线上环境凌晨5分有个定时任务执行了，但是执行过程中有报错，导致数据全部回滚，报错信息如下： ### Cause: java.sql.SQLException: connection holder is null ; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; connection holder...
Spring Boot + Mybatis: 整合Druid实现多数据源配置实例
本文将详细介绍如何在Spring Boot项目中整合Mybatis框架并利用Druid实现多数据源的配置。首先，我们先了解多数据源应用场景，尤其是在处理大规模数据时，为了优化性能和负载均衡，通常会配置主从库，例如将频繁访问...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值