JDBC的配置:
<bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource">
<property name="driver" value="${jdbc.driver}" />
<property name="driverUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="alias" value="BnetDBPool" />
<property name="prototypeCount" value="5" />
<property name="maximumConnectionCount" value="100" />
<property name="minimumConnectionCount" value="10" />
<property name="houseKeepingTestSql" value="select CURRENT_DATE" />
</bean>
<property name="driver" value="${jdbc.driver}" />
<property name="driverUrl" value="${jdbc.url}" />
<property name="user" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="alias" value="BnetDBPool" />
<property name="prototypeCount" value="5" />
<property name="maximumConnectionCount" value="100" />
<property name="minimumConnectionCount" value="10" />
<property name="houseKeepingTestSql" value="select CURRENT_DATE" />
</bean>
红色字体标注的配置过小会出现错误;
DBCP配置:
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<!-- Connection Info -->
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="maxActive">
<value>500</value>
</property>
<property name="initialSize">
<value>1</value>
</property>
<property name="maxWait">
<value>60000</value>
</property>
<property name="maxIdle">
<value>100</value>
</property>
<property name="minIdle">
<value>1</value>
</property>
<property name="removeAbandoned">
<value>true</value>
</property>
<property name="removeAbandonedTimeout">
<value>1800</value>
</property>
</bean>
<!-- Connection Info -->
<property name="driverClassName" value="${jdbc.driver}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
<property name="maxActive">
<value>500</value>
</property>
<property name="initialSize">
<value>1</value>
</property>
<property name="maxWait">
<value>60000</value>
</property>
<property name="maxIdle">
<value>100</value>
</property>
<property name="minIdle">
<value>1</value>
</property>
<property name="removeAbandoned">
<value>true</value>
</property>
<property name="removeAbandonedTimeout">
<value>1800</value>
</property>
</bean>
红色标注根据需要可有可无,绿色标注如果配置过大,启动时会很慢,大概2到3分钟。个人的测试结果不足以说服大众。再次已记录此次中间遇到的问题。