环境: myEclipse9.1
Dbcp ,c3p0 , jndi, 这几种是现在普遍使用的数据库连接池。而在最近一年内,官方发布了最新的数据库连接池,BoneCP,此连接池速度据官方统计,快c3p0 25倍。
单线程
Single Thread
1,000,000 get connection / release connection requests
No delay between getting/releasing connection.
Pool size range: 20-50.
Acquire increment: 5
Helper threads: 1
Partition count: 1
多线程
Multi-Thread
500 threads each attempting 100 get/release connection
No delay between getting/releasing connection.
Pool size range: 50-200.
Acquire increment: 5
Helper threads: 5
BoneCP数据连接池使用方法和其他连接池大同小异,非常简单,以下代码为配置连接池
import com.jolbox.bonecp.BoneCPDataSource;
public class BoneCP {
private BoneCPDataSource ds;
public BoneCP()
{
ds = new BoneCPDataSource();
ds.setDriverClass("com.microsoft.sqlserver.jdbc.SQLServerDriver");
ds.setJdbcUrl("jdbc:sqlserver://localhost:1433;databaseName=TestDB");
ds.setUsername("sa");
ds.setPassword("accp");
}
public Connection GetConn()
{
try {
return ds.getConnection();
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
}