<bean id="sourceParentDataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="initialSize" value="10" />
<property name="maxActive" value="10" />
<property name="maxWait" value="1000" />
<property name="maxIdle" value="5" />
<property name="minIdle" value="5" />
<property name="testOnBorrow" value="false" />
<property name="testOnReturn" value="false" />
<property name="testWhileIdle" value="true" />
<property name="timeBetweenEvictionRunsMillis" value="300000" />
<!-- 是否被空闲线程给检查,默认为false -->
<property name="validationQuery" value="select 1" />
<!-- 被遗弃的连接可以多久之后被抛弃的时间 -->
<property name="removeAbandoned" value="true" />
<property name="removeAbandonedTimeout" value="30" />
</bean>
复制代码
source.mysql.url_0=jdbc:mysql://aaa.mysql.jddb.com:3306/ordervvv?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&connectTimeout=1000&socketTimeout=5000
复制代码