vibur-dbcp 是一个并发、快速和功能齐全的 JDBC 连接池，提供先进的性能监控功能。本文主要介绍 vibur-dbcp 的基本使用，文中使用到的软件版本：Java 1.8.0_191、vibur-dbcp 25.0、Spring Boot 2.3.12.RELEASE。

1、配置参数

1.1、连接池大小及公平性配置

1.2、基础配置

1.3、连接超时及重试

1.4、连接校验

1.5、查询慢及大结果集日志设置

1.6、获取连接慢及超时日志设置

1.7、回调函数

回调函数只能在配置阶段设置，且启动后不能修改。

1.8、连接默认行为设置

1.9、Statement 缓存设置

1.10、连接池缩小设置

1.11、严重 SQL 状态

1.12、启用 JMX

详细说明可参考官网文档：http://www.vibur.org/

2、使用

2.1、直接使用

2.1.1、引入依赖

<dependency>
    <groupId>org.vibur</groupId>
    <artifactId>vibur-dbcp</artifactId>
    <version>25.0</version>
</dependency>
<dependency>
    <groupId>com.googlecode.concurrentlinkedhashmap</groupId>
    <artifactId>concurrentlinkedhashmap-lru</artifactId>
    <version>1.4.2</version>
</dependency>

2.1.2、使用例子

package com.abc.demo.general.dbpool;

import org.vibur.dbcp.ViburDBCPDataSource;

import java.sql.*;

public class ViburDbcpCase {
    public static void main(String[] args) {
        ViburDBCPDataSource viburDBCPDataSource = new ViburDBCPDataSource();
        viburDBCPDataSource.setName("vibur-dbcp连接池");
        viburDBCPDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver");
        viburDBCPDataSource.setJdbcUrl("jdbc:mysql://10.40.9.11:3306/mydb?useUnicode=true&characterEncoding=UTF-8");
        viburDBCPDataSource.setUsername("root");
        viburDBCPDataSource.setPassword("123456");
        viburDBCPDataSource.setPoolInitialSize(2);
        viburDBCPDataSource.setPoolMaxSize(10);
        viburDBCPDataSource.setConnectionIdleLimitInSeconds(30);
        viburDBCPDataSource.setTestConnectionQuery("select 1");
        viburDBCPDataSource.setLogQueryExecutionLongerThanMs(5000);
        viburDBCPDataSource.setLogStackTraceForLongQueryExecution(true);
        viburDBCPDataSource.setStatementCacheMaxSize(200);
        viburDBCPDataSource.start();

        Connection connection = null;
        try {
            connection = viburDBCPDataSource.getConnection();
            Statement st = connection.createStatement();
            ResultSet rs = st.executeQuery("select version()");
            if (rs.next()) {
                System.out.println(rs.getString(1));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            close(connection);
        }

        //实际使用中一般是在应用启动时初始化数据源，应用从数据源中获取连接；并不会关闭数据源。
        viburDBCPDataSource.close();
    }

    private static void close(Connection connection) {
        if (connection != null) {
            try {
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}

2.2、在 SpringBoot 中使用

2.1.1、引入依赖

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.3.12.RELEASE</version>
    <relativePath />
</parent>

<dependencies>
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-web</artifactId>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
    </dependency>

    <dependency>
        <groupId>org.vibur</groupId>
        <artifactId>vibur-dbcp</artifactId>
        <version>25.0</version>
    </dependency>
    <dependency>
        <groupId>com.googlecode.concurrentlinkedhashmap</groupId>
        <artifactId>concurrentlinkedhashmap-lru</artifactId>
        <version>1.4.2</version>
    </dependency>

    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
    </dependency>
</dependencies>

2.1.2、单数据源

application.yml 配置：

spring:
  datasource:
    vibur:
      name: vibur-dbcp连接池
      driver-class-name: com.mysql.cj.jdbc.Driver
      jdbc-url: jdbc:mysql://10.110.74.187:3306/egmp?useUnicode=true&characterEncoding=UTF-8
      username: root
      password: InsYR0ot187!
      pool-initial-size: 2
      pool-max-size: 10
      connection-idle-limit-in-seconds: 30
      test-connection-query: select 1
      log-query-execution-longer-than-ms: 5000
      log-stack-trace-for-long-query-execution: true
      statement-cache-max-size: 200

数据源配置类：

package com.abc.demo.config;

import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.vibur.dbcp.ViburDBCPDataSource;


@Configuration
public class DataSourceConfig {
    @Bean(name = "dataSource", initMethod = "start")
    @ConfigurationProperties(prefix = "spring.datasource.vibur")
    public ViburDBCPDataSource dataSource() {
        ViburDBCPDataSource dataSource = DataSourceBuilder.create().type(ViburDBCPDataSource.class).build();
        return dataSource;
    }
}

使用：

@Autowired
private DataSource dataSource;

2.1.3、多数据源

application.yml 配置：

spring:
  datasource:
    vibur:
      db1:
        name: vibur-dbcp连接池1
        driver-class-name: com.mysql.cj.jdbc.Driver
        jdbc-url: jdbc:mysql://10.110.74.187:3306/egmp?useUnicode=true&characterEncoding=UTF-8
        username: root
        password: InsYR0ot187!
        pool-initial-size: 2
        pool-max-size: 10
        connection-idle-limit-in-seconds: 30
        test-connection-query: select 1
        log-query-execution-longer-than-ms: 5000
        log-stack-trace-for-long-query-execution: true
        statement-cache-max-size: 200
      db2:
        name: vibur-dbcp连接池2
        driver-class-name: com.mysql.cj.jdbc.Driver
        jdbc-url: jdbc:mysql://10.110.74.187:3306/egmp?useUnicode=true&characterEncoding=UTF-8
        username: root
        password: InsYR0ot187!
        pool-initial-size: 2
        pool-max-size: 10
        connection-idle-limit-in-seconds: 30
        test-connection-query: select 1
        log-query-execution-longer-than-ms: 5000
        log-stack-trace-for-long-query-execution: true
        statement-cache-max-size: 200

数据源配置类：

package com.abc.demo.config;

import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.vibur.dbcp.ViburDBCPDataSource;


@Configuration
public class DataSourceConfig {
    @Primary
    @Bean(name = "dataSource1", initMethod = "start")
    @ConfigurationProperties("spring.datasource.vibur.db1")
    public ViburDBCPDataSource dataSourceOne(){
        return DataSourceBuilder.create().type(ViburDBCPDataSource.class).build();
    }

    @Bean(name = "dataSource2", initMethod = "start")
    @ConfigurationProperties("spring.datasource.vibur.db2")
    public ViburDBCPDataSource dataSourceTwo(){
        return DataSourceBuilder.create().type(ViburDBCPDataSource.class).build();
    }
}

使用：

@Autowired
@Qualifier("dataSource1")
private DataSource dataSource1;

@Autowired
@Qualifier("dataSource2")
private DataSource dataSource2;