spring配置dbcp连接池
一、配置db.properties属性文件
#database connection config connection.username=sa connection.password=sa connection.url=jdbc:sqlserver://192.168.10.3:1433;databaseName=Adw connection.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver #connection.initialSize=10 connection.maxActive=100 connection.maxIdle=30 connection.minIdle=5 connection.maxWait=5000 connection.removeAbandoned=true connection.removeAbandonedTimeout=3000 connection.logAbandoned=false
二、spring配置文件中,配置读取db.properties文件的bean
<bean id="config" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer"> <property name="location"> <value>classpath:db.properties</value> </property> </bean>
三、最后配置dataSource
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="username" value="${connection.username}"></property>
<property name="password" value="${connection.password}"></property>
<property name="url" value="${connection.url}"></property>
<property name="driverClassName" value="${connection.driverClassName}"></property>
<!-- <property name="initialSize" value="${connection.initialSize}"></property> -->
<property name="maxActive" value="${connection.maxActive}"></property>
<property name="maxIdle" value="${connection.maxIdle}"></property>
<property name="minIdle" value="${connection.minIdle}"></property>
<property name="maxWait" value="${connection.maxWait}"></property>
<property name="removeAbandoned" value="${connection.removeAbandoned}"></property>
<property name="removeAbandonedTimeout" value="${connection.removeAbandonedTimeout}"></property>
<property name="logAbandoned" value="${connection.logAbandoned}"></property>
</bean>dbcp从1.2开始有支持initialSize属性，不过通过Maven获取的包好像还不支持
官方参考文档http://commons.apache.org/dbcp/configuration.html