spring中以dataSource方式使用proxool连接池
(by goodhumor)
方式一:
在Spring的"applicationContext.xml"中的dataSource bean定义——
<
bean
id
="dataSource"
class ="org.logicalcobwebs.proxool.ProxoolDataSource" >
< property name ="driver" >
< value > com.mysql.jdbc.Driver </ value >
</ property >
< property name ="driverUrl" >
< value > jdbc:mysql://localhost:3306/dbname?user=yourname & password=yourpass </ value >
</ property >
< property name ="user" value ="yourname" />
< property name ="password" value ="yourpass" />
< property name ="alias" value ="Pool_dbname" />
< property name ="houseKeepingSleepTime" value ="90000" />
< property name ="prototypeCount" value ="0" />
< property name ="maximumConnectionCount" value ="50" />
< property name ="minimumConnectionCount" value ="2" />
class ="org.logicalcobwebs.proxool.ProxoolDataSource" >
< property name ="driver" >
< value > com.mysql.jdbc.Driver </ value >
</ property >
< property name ="driverUrl" >
< value > jdbc:mysql://localhost:3306/dbname?user=yourname & password=yourpass </ value >
</ property >
< property name ="user" value ="yourname" />
< property name ="password" value ="yourpass" />
< property name ="alias" value ="Pool_dbname" />
< property name ="houseKeepingSleepTime" value ="90000" />
< property name ="prototypeCount" value ="0" />
< property name ="maximumConnectionCount" value ="50" />
< property name ="minimumConnectionCount" value ="2" />