SSH框架整合连接池proxool的配置
1. 添加所需架包：proxool-0.9.jar.
2. 准备属性文件：pool.properties.
?
#pool-proxooldriver=com.mysql.jdbc.DriverdriverUrl=jdbc\:mysql\://127.0.0.1\:3306/StudentDB?user\=root&password\=***&useUnicode\=true&characterEncoding\=utf-8&characterSetResults\=UTF-8user=rootpassword=***alias=proxoolPoolhouseKeepingSleepTime=30000prototypeCount=20minimumConnectionCount=5maximumConnectionCount=30maximumActiveTime=300000trace=trueverbose=truehouseKeepingTestSql=select CURRENT_DATEsimultaneousBuildThrottle=50
?
3. 修改spring配置文件
?
<!-- ========================================================= --> <!-- 加载属性文件 --> <!-- ========================================================= --><context:property-placeholder location="/WEB-INF/*.properties"/> <!-- ========================================================= --> <!-- 配置 proxool 连接池 --> <!-- ========================================================= --><bean id="dataSource" value="${driver}" /><property name="driverUrl" value="${driverUrl}" /><property name="user" value="${user}" /><property name="password" value="${password}" /><property name="alias" value="${alias}" /><property name="maximumActiveTime" value="${maximumActiveTime}" /><property name="prototypeCount" value="${prototypeCount}" /><property name="trace" value="${trace}" /><property name="verbose" value="${verbose}" /><property name="houseKeepingSleepTime" value="${houseKeepingSleepTime}" /><property name="maximumConnectionCount" value="${maximumConnectionCount}" /><property name="minimumConnectionCount" value="${simultaneousBuildThrottle}" /><property name="simultaneousBuildThrottle" value="${simultaneousBuildThrottle}" /><property name="houseKeepingTestSql" value="${houseKeepingTestSql}" /></bean>?
?