spring dbcp连接池配置 BasicDataSource

太过爱你忘了你带给我的痛 2022-04-08 09:44 373阅读 0赞

spring配置

<context:property-placeholder location="classpath:jdbc.properties" />
    
    <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"  destroy-method="close">
    	<property name="driverClassName" value="${jdbc.driverClassName}" />
    	<property name="url" value="${jdbc.url}" />
    	<property name="username" value="${jdbc.username}" />
    	<property name="password" value="${jdbc.password}" />
    	
    	
    	<property name="initialSize" value="2" />
    	
    	<property name="minIdle" value="2" />
    	
    	<property name="maxActive" value="8" />
    	
    	<property name="maxIdle" value="5" />
    	
    	<property name="maxWait" value="60000" />
    	
    	<property name="removeAbandoned" value="true" />
    	
    	<property name="removeAbandonedTimeout" value="180" />
    	
    	
    	
    	
    	<property name="testWhileIdle" value="true" />
    	
    	<property name="testOnBorrow" value="true" />
    	
    	<property name="testOnReturn" value="false" />
    	
    	<property name="validationQuery">
    		<value>select current date from sysibm.SYSDUMMY1</value>
    	</property>
    	
    	<property name="validationQueryTimeout" value="1" />
    	
    	<property name="timeBetweenEvictionRunsMillis" value="60000" />
    	
    	<property name="numTestsPerEvictionRun" value="8" />
    </bean>

jdbc.properties

#db2
    jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver
    jdbc.url=jdbc:db2://localhost:50000/dbname
    jdbc.username=username
    jdbc.password=password
    
    ##mysql
    #jdbc.driverClassName=com.mysql.jdbc.Driver
    #jdbc.url=jdbc:mysql://localhost:3306/dbname?useUnicode=true&characterEncoding=utf-8
    #jdbc.username=root
    #jdbc.password=password
    
    ##oracle
    #jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
    #jdbc.url=jdbc:oracle:thin:@localhost:1521:sid
    #jdbc.username=username
    #jdbc.password=password

DBCP 应用的总结（一）

http://blog.csdn.net/fover717/article/details/8121936

dbcp配置

http://blog.csdn.net/yyf\_ad/article/details/17762795

dbcp基本配置和重连配置

http://blog.itpub.net/7971010/viewspace-1114524