# BeeCP
**Repository Path**: olived/BeeCP
## Basic Information
- **Project Name**: BeeCP
- **Description**: 一款小型JDBC连接池组件
- **Primary Language**: Java
- **License**: LGPL-2.1
- **Default Branch**: master
- **Homepage**: https://www.oschina.net/p/beecp
- **GVP Project**: No
## Statistics
- **Stars**: 0
- **Forks**: 44
- **Created**: 2023-11-27
- **Last Updated**: 2023-11-27
## Categories & Tags
**Categories**: Uncategorized
**Tags**: None
## README
## :coffee: Introduction
BeeCP, a small JDBC connection pool: high performance, lightweight code and good stability.
* Support main popular database drivers
* Support XAConnection/JTA
* Pool features:CAS,single connection cache, queue reuse, non move waiting self spin, asynchronous add , safe close,web monitor and so on
* Good robustness and quick response to unexpected situations (such as network disconnection and database service crash)
* Good interface extensibility
## :arrow_down: Download
Java7 or higher
```xml
com.github.chris2018998
beecp
3.4.2
```
Java6
```xml
com.github.chris2018998
beecp
1.6.10
```
## :tractor: Example
### :point_right: Example-1(independent)
```java
BeeDataSourceConfig config = new BeeDataSourceConfig();
config.setDriverClassName("com.mysql.jdbc.Driver");
config.setJdbcUrl("jdbc:mysql://localhost/test");
config.setUsername("root");
config.setPassword("root");
BeeDataSource ds=new BeeDataSource(config);
Connection con=ds.getConnection();
....
```
### :point_right: Example-2(Springbooot)
*application.properties*
```java
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.url=jdbc:mysql://localhost/test
spring.datasource.driverClassName=com.mysql.jdbc.Driver
```
*DataSourceConfig.java*
```java
@Configuration
public class DataSourceConfig {
@Value("${spring.datasource.username}")
private String user;
@Value("${spring.datasource.password}")
private String password;
@Value("${spring.datasource.url}")
private String url;
@Value("${spring.datasource.driverClassName}")
private String driver;
@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));
}
}
```
## :book: Function map
## :computer: Runtime monitor
Three ways are provided in pool
* slf4j log
* Jmx mbean
* Pool Vo(get it by call datasource method:getPoolMonitorVo)
:sunny: *If your project is using beecp and base on springboot, we recommend our datasource management tool:BeeCP-Starter (web ui, no code development ,just some configuration)*
## :cherries: Compare to HikariCP
| **Compare Item** |**BeeCP** | **HikariCP** |
|---------------------------------|--------------------------------------------------------| ------------------------------------------------- |
| key technology |ThreadLocal，Semaphore，ConcurrentLinkedQueue，Thread | FastList，ConcurrentBag，ThreadPoolExecutor |
| Similarities |CAS，pre-generate proxy，driver statement cache | |
| Difference |fair mode，supprt XA，recycle hold-timeout connection，single connection cache，queue reuse，non move waiting spin|pool pause|
| Files |37 files，95KB Jar |44 files，158KB Jar |
| Performance |40 percent faster （HikariCP bench） |
## :green_apple: Code quality
## :factory: User Extend
### 1：Connection factory interfaces
Two interfaces,which are using to create raw connection or raw XAConnection for self-implement and its subclass name need set to 'connectionFactoryClassName' in Bee DataSourceConfig object.
Example
### 2：Jdbc password ciphertext decrypt class
## :blue_book: Configuration
|**Item Name** |**Desc** |**Default** |
| ---------------------------------| ------------------------------------- | ----------------------------------- |
|username |jdbc username |empty |
|password |jdbc password |empty |
|jdbcUrl |jdbc url |empty |
|driverClassName |jdbc driver class name |empty |
|poolName |pool name,if not set,auto generated |empty |
|fairMode |indicator,true:pool will use fair semaphore and fair transfer policy|false |
|initialSize |size of connections on pool starting |0 |
|maxActive |max reachable size of connections in pool |10 |
|borrowSemaphoreSize |max permit size of pool semaphore |min(maxActive/2,CPU core size） |
|defaultAutoCommit |'autoCommit' property default value |true |
|defaultTransactionIsolationCode |'transactionIsolation'property default value,if not set,then read out from first connection|-999|
|defaultCatalog |'catalog' property default value |empty |
|defaultSchema |'schema' property default value |empty |
|defaultReadOnly |'readOnly' property default value |false |
|maxWait |milliseconds:max wait time to get one connection from pool|8000 |
|idleTimeout |milliseconds:max idle time of connections,when reach,then close them and remove from pool|18000|
|holdTimeout |milliseconds:max no-use time of borrowed connections,when reach,then return them to pool by forced close |18000 |
|validTestSql |connection valid test sql on borrowed |SELECT 1 |
|validTestTimeout |seconds:max time to get valid test result |3 |
|validAssumeTime |milliseconds:connections valid assume time after last activity,if borrowed,not need test during the duration |500 |
|forceCloseUsingOnClear |using connections forced close indicator on pool clear|false |
|delayTimeForNextClear |milliseconds:delay time for next loop to clear,whenforceCloseUsingOnClear is false and exists using connections |3000 |
|timerCheckInterval |milliseconds:interval time to run timer check task|18000 |
|connectionFactoryClassName |raw JDBC connection factory class name |empty |
|enableJmx |boolean indicator,true:register dataSource to jmx |false |
|printConfigInfo |boolean indicator,true:print config item info on pool starting|false |
|printRuntimeLog |boolean indicator,true:print runtime log |false |