BoneCP(马勒・格・彼得)

 1) BoneCP加入工程

Xml代码 

<dependency>
	<groupId>com.jolbox</groupId>
	<artifactId>bonecp</artifactId>
	<version>0.7.1.RELEASE</version>
</dependency>

2)bonecp.properties放在classpath下

Properties代码   

##################################################################################
# BoneCP 数据库连接池
##################################################################################

#---------------------------------------------------------------------------------
# 基本设置
#---------------------------------------------------------------------------------
bonecp.driverClass=com.mysql.jdbc.Driver
bonecp.jdbcUrl=jdbc:mysql://localhost:3306/test
bonecp.username=root
bonecp.password=root

#---------------------------------------------------------------------------------
# 高级设置
#  idleConnectionTestPeriodInMinutes - 检查数据库连接池中空闲连接的间隔时间(分) 默认：240
#  idleMaxAgeInMinutes - 连接池中未使用的链接最大存活时间(分) 默认：240
#  minConnectionsPerPartition - 每个分区最小的连接数
#  maxConnectionsPerPartition - 每个分区最大的连接数
#  partitionCount - 分区数 默认值：2，最小值：1，
#  acquireIncrement - 连接数不够时，每次创建的新链接个数 默认值：2
#  statementsCacheSize - Statement实例缓存个数 默认值：0
#  releaseHelperThreads - 每个分区释放链接助理进程的数量 默认值：3
#---------------------------------------------------------------------------------
bonecp.idleConnectionTestPeriodInMinutes=240
bonecp.idleMaxAgeInMinutes=60
bonecp.minConnectionsPerPartition=5
bonecp.maxConnectionsPerPartition=15
bonecp.partitionCount=1
bonecp.acquireIncrement=2
bonecp.statementsCacheSize=0
bonecp.releaseHelperThreads=3

 

3)在Spring中配置数据源

 

Xml代码     

<context:property-placeholder location="classpath:bonecp.properties" />

<bean id="dataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close">
	<property name="driverClass" value="${bonecp.driverClass}" />
	<property name="jdbcUrl" value="${bonecp.jdbcUrl}" />
	<property name="username" value="${bonecp.username}" />
	<property name="password" value="${bonecp.password}" />
	<property name="idleConnectionTestPeriodInMinutes" value="${bonecp.idleConnectionTestPeriodInMinutes}" />
	<property name="idleMaxAgeInMinutes" value="${bonecp.idleMaxAgeInMinutes}" />
	<property name="minConnectionsPerPartition" value="${bonecp.minConnectionsPerPartition}" />
	<property name="maxConnectionsPerPartition" value="${bonecp.maxConnectionsPerPartition}" />
	<property name="partitionCount" value="${bonecp.partitionCount}" />
	<property name="acquireIncrement" value="${bonecp.acquireIncrement}" />
	<property name="statementsCacheSize" value="${bonecp.statementsCacheSize}" />
	<property name="releaseHelperThreads" value="${bonecp.releaseHelperThreads}" />
</bean>