DBCP连接池配置参数说明 .

阳光穿透心脏的1/2处 2022-03-19 06:23 253阅读 0赞

<bean id="dataSource"
              class="org.apache.commons.dbcp.BasicDataSource"
              destroy-method="close">
            <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://192.168.0.109:3306/test?useUnicode=true&characterEncoding=UTF-8"/>
            <property name="username" value="root"/>
            <property name="password" value="root"/>
              
            <property name="maxActive" value="150"/>
              
            <property name="minIdle" value="5"/>
              
            <property name="maxIdle" value="20"/>
              
            <property name="initialSize" value="30"/>
            
            <property name="logAbandoned" value="true"/>
              
            <property name="removeAbandoned"  value="true"/>
              
            <property name="removeAbandonedTimeout" value="10"/>
            
            <property name="maxWait" value="1000"/>
            
            <property name="timeBetweenEvictionRunsMillis" value="10000"/>
            
            <property name="numTestsPerEvictionRun" value="10"/>
            
            <property name="minEvictableIdleTimeMillis" value="10000"/>
    	<property name="validationQuery" value="SELECT NOW() FROM DUAL"/>
        </bean>