总结spring下配置dbcp,c3p0,proxool数据源链接池
转载于：http://hiok.blog.sohu.com/66253191.html

applicationContext-datasource-jdbc.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC    "-//SPRING//DTD BEAN//EN"    "http://www.springframework.org/dtd/spring-beans.dtd">
<beans default-autowire="no" default-lazy-init="true" default-dependency-check="none">
<description>datasource</description>
<!--      <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 
<property name="driverClassName">
<value>${jdbc.driverClassName}</value>
</property> 
<property name="url">
<value>${jdbc.url}</value>
</property> 
<property name="username">
<value>${jdbc.username}</value>
</property> 
<property name="password">
<value>${jdbc.password}</value>
</property>
</bean>-->

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName">
<value>${jdbc.driverClassName}</value>
</property>   
<property name="url">
<value>${jdbc.url}</value>
</property>   
<property name="username">
<value>${jdbc.username}</value>
</property>   
<property name="password">
<value>${jdbc.password}</value>
</property>   
<property name="maxActive">
<value>80</value>
</property>     
<property name="maxIdle">
<value>20</value>
</property>     
<property name="maxWait">
<value>3000</value>
</property>     
</bean>


<!--bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">       
<property name="driverClass">
<value>${jdbc.driverClassName}</value>
</property>       
<property name="jdbcUrl">
<value>${jdbc.url}</value>
</property>       
<property name="user">
<value>${jdbc.username}</value>
</property>       
<property name="password">
<value>${jdbc.password}</value>
</property>         
<property name="acquireIncrement">
<value>5</value>
</property>       
<property name="idleConnectionTestPeriod">
<value>3000</value>
</property>       
<property name="checkoutTimeout">
<value>3000</value>
</property>       
<property name="maxPoolSize">
<value>80</value>
</property>      
<property name="minPoolSize">
<value>1</value>
</property>      <property name="maxStatements">
<value>6000</value>
</property>       
<property name="initialPoolSize">
<value>5</value>
</property>
</bean-->
<!--ComboPooledDataSource 参数说明
maxIdleTime：最大