Chris2018998 / Beecp

English|中文

BeeCP：A lightweight,high-performance JDBC pool

Maven artifact(Java7)

<dependency>
   <groupId>com.github.chris2018998</groupId>
   <artifactId>beecp</artifactId>
   <version>3.1.2</version>
</dependency>

Maven artifact(Java6)

<dependency>
   <groupId>com.github.chris2018998</groupId>
   <artifactId>beecp</artifactId>
   <version>1.6.9</version>
</dependency>

Performance

1： One million Mutil-thread query (10000 threads x 10 times) | Pool type | HikariCP-3.4.5 | beecp-3.0.5_compete|
| --------------- |---------------- | ----------------- |
| Average time(ms) |25.132750 | 0.284550 |

SQL:select 1 from dual

PC:I5-4210M(2.6Hz,dual core4threads),12G memory Java:JAVA8_64 Pool:init-size10,max-size:10

Test log file：JDBCPool2020-11-06.log

Test soruce：https://github.com/Chris2018998/PoolPerformance

2： Test with HikariCP performance benchmark(I3-7100,8G)

Test source：HikariCP-benchmark_BeeCP.zip

Example-1

BeeDataSourceConfig config = new BeeDataSourceConfig();
config.setDriverClassName("com.mysql.jdbc.Driver");
config.setJdbcUrl("jdbc:mysql://localhost/test");
config.setUsername("root");
config.setPassword("root");
config.setMaxActive(10);
config.setInitialSize(0);
config.setMaxWait(8000);//ms
//DataSource ds=new BeeDataSource(config);
BeeDataSource ds=new BeeDataSource(config);
Connection con=ds.getConnection();
....

Example-2（SpringBoot）

application.properties

spring.datasource.username=xx
spring.datasource.password=xx
spring.datasource.url=xx
spring.datasource.driverClassName=xxx
spring.datasource.datasourceJndiName=xxx

DataSourceConfig.java

@Configuration
public class DataSourceConfig {
  @Value("${spring.datasource.driverClassName}")
  private String driver;
  @Value("${spring.datasource.url}")
  private String url;
  @Value("${spring.datasource.username}")
  private String user;
  @Value("${spring.datasource.password}")
  private String password;
  @Value("${spring.datasource.datasourceJndiName}")
  private String datasourceJndiName;
  private BeeDataSourceFactory dataSourceFactory = new BeeDataSourceFactory();
  
  @Bean
  @Primary
  @ConfigurationProperties(prefix="spring.datasource")
  public DataSource primaryDataSource() {
    return DataSourceBuilder.create().type(cn.beecp.BeeDataSource.class).build();
  }
  
  @Bean
  public DataSource secondDataSource(){
    return new BeeDataSource(new BeeDataSourceConfig(driver,url,user,password));
  }
  
  @Bean
  public DataSource thirdDataSource()throws SQLException {
    try{
       return dataSourceFactory.lookup(datasourceJndiName);
     }catch(NamingException e){
       throw new SQLException("Jndi DataSource not found："+datasourceJndiName);
     }
  }
}

Features

1：Borrow timeout

2：Fair mode and compete mode for borrowing

3：Proxy object safe close when return

4：Pooled connection cleared when network bad,pooled connection recreate when network restore OK

5：Idle timeout and hold timeout(long time inactively hold by borrower)

6：Connection transaction rollback if exist commit transaction when return

7：Pooled connection closed when exception,then create new one and transfer it to waiter

8：Pooled connection attributes reset when return（autoCommit,transactionIsolation,readonly,catlog,schema,networkTimeout）

9：XADataSource support

10：support self defined connection factory

11：Pool Reset

12：JMX support

Configuration

DB and driver