DBCP 与C3P0的设置,避免CONNECTION用光的情况

DBCP的设置如下:

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
  <property name="driverClassName">
   <value>${jdbc.driverClassName}</value>
  </property>
  <property name="url">
   <value>${esales.jdbc.url}</value>
  </property>
  <property name="username">
   <value>${esales.jdbc.username}</value>
  </property>
  <property name="password">
   <value>${esales.jdbc.password}</value>
  </property>
  <property name="maxActive">
   <value>60</value>
  </property>
  <property name="maxIdle">
   <value>50</value>
  </property>
  <property name="logAbandoned">
   <value>true</value>
  </property>
  <property name="testOnBorrow">
   <value>true</value>
  </property>
  <property name="testOnReturn">
   <value>true</value>
  </property>
  <property name="testWhileIdle">
   <value>true</value>
  </property>
  <property name="validationQuery">
   <value>select 1</value>
  </property>
  <property name="removeAbandoned">
   <value>true</value>
  </property>
  <property name="removeAbandonedTimeout">
   <value>180</value>
  </property>
  <property name="maxWait">
   <value>5000</value>
  </property>
 </bean>

 

C3PO的设置:

 

db.driverClass=net.sourceforge.jtds.jdbc.Driver
db.minPoolSize = 5
db.maxPoolSize = 30
db.maxIdleTime = 60
db.acquireIncrement = 5
db.maxStatements = 0
db.initialPoolSize=10
db.acquireRetryAttempts=60
db.acquireRetryDelay = 60000
db.breakAfterAcquireFailure=true
db.checkoutTimeout=30000
db.testConnectionOnCheckout=false
db.testConnectionOnCheckin=true
db.idleConnectionTestPeriod = 60
db.preferredTestQuery = select 1

 

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
  destroy-method="close">
  <property name="driverClass">
   <value>${db.driverClass}</value>
  </property>
  <property name="jdbcUrl">
   <value>${db.mas.jdbcurl}</value>
  </property>
  <property name="user">
   <value>${db.mas.userName}</value>
  </property>
  <property name="password">
   <value>${db.mas.password}</value>
  </property>
  <property name="minPoolSize">
   <value>${db.minPoolSize}</value>
  </property>
  <property name="maxPoolSize">
   <value>${db.maxPoolSize}</value>
  </property>
  <property name="maxIdleTime">
   <value>${db.maxIdleTime}</value>
  </property>
  <property name="acquireIncrement">
   <value>${db.acquireIncrement}</value>
  </property>
  <property name="maxStatements">
   <value>${db.maxStatements}</value>
  </property>
  <property name="initialPoolSize">
   <value>${db.initialPoolSize}</value>
  </property>
  <property name="acquireRetryAttempts">
   <value>${db.acquireRetryAttempts}</value>
  </property>
  <property name="acquireRetryDelay">
   <value>${db.acquireRetryDelay}</value>
  </property>
  <property name="breakAfterAcquireFailure">
   <value>${db.breakAfterAcquireFailure}</value>
  </property>
  <property name="checkoutTimeout">
   <value>${db.checkoutTimeout}</value>
  </property>
  <property name="testConnectionOnCheckout">
   <value>${db.testConnectionOnCheckout}</value>
  </property>
  <property name="testConnectionOnCheckin">
   <value>${db.testConnectionOnCheckin}</value>
  </property>
  <property name="idleConnectionTestPeriod">
   <value>${db.idleConnectionTestPeriod}</value>
  </property>
  <property name="preferredTestQuery">
   <value>${db.preferredTestQuery} </value>
  </property>
 </bean>