spring 的连接池

hibernate开发组推荐c3p0

spring开发组推荐dbcp 

dbcp的配置：

#连接设置
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@127.0.0.1:1521:DBSERVER
jdbc.username=user
jdbc.password=pass

#<!-- 初始化连接 -->
dataSource.initialSize=10

#<!-- 最大空闲连接 -->
dataSource.maxIdle=20

#<!-- 最小空闲连接 -->
dataSource.minIdle=5

#最大连接数量
dataSource.maxActive=50

#是否在自动回收超时连接的时候打印连接的超时错误
dataSource.logAbandoned=true

#是否自动回收超时连接
dataSource.removeAbandoned=true

#超时时间(以秒数为单位)
dataSource.removeAbandonedTimeout=180

#<!-- 超时等待时间以毫秒为单位 6000毫秒/1000等于60秒 -->
dataSource.maxWait=1000

< bean  id ="dataSource"  class ="org.apache.commons.dbcp.BasicDataSource"  destroy-method ="close" >
< property  name ="driverClassName"  value ="${db.driverClassName}" />
< property  name ="url"  value ="${db.url}" />
< property  name ="username"  value ="${db.username}" />
< property  name ="password"  value ="${db.password}" />

  < property  name ="validationQuery" >
< value > SELECT 1 </ value >
</ property >
< property  name ="testOnBorrow" >
< value > true </ value >
</ property >
</ bean >

c3p0的配置：

< bean  id ="fidsDatasource"    
        class ="com.mchange.v2.c3p0.ComboPooledDataSource"  
        destroy-method ="close" >
         < property  name ="driverClass" >
             < value > ${db.driverClass} </ value >
         </ property >
         < property  name ="jdbcUrl" >             
             < value > ${db.jdbcurl} </ value >
         </ property >
         < property  name ="user" >
             < value > ${db.user} </ value >
         </ property >
         < property  name ="password" >
             < value > ${db.password} </ value >
         </ property >
         < property  name ="minPoolSize" >
             < value > 15 </ value >
         </ property >
         < property  name ="acquireIncrement" >
             < value > 10000 </ value >
         </ property >
         < property  name ="maxPoolSize" >
             < value > 25 </ value >
         </ property >
     </ bean >