C3P0连接池详细配置与实现

朱雀 2020-10-31 17:27 678阅读 0赞

C3P0连接池详细配置与实现  
````
<c3p0-config>  
  <default-config>  
   
 <property name="acquireIncrement">3</property>  
   
   
 <property name="acquireRetryAttempts">30</property>  
   
   
 <property name="acquireRetryDelay">1000</property>  
   
   
 <property name="autoCommitOnClose">false</property>  
   
   
 <property name="automaticTestTable">Test</property>  
   
   
 <property name="breakAfterAcquireFailure">false</property>  
   
   
 <property name="checkoutTimeout">100</property>  
   
   
 <property name="connectionTesterClassName"></property>  
   
   
 <property name="factoryClassLocation">null</property>  
   
   
 <property name="forceIgnoreUnresolvedTransactions">false</property>  
   
   
 <property name="idleConnectionTestPeriod">60</property>  
   
   
 <property name="initialPoolSize">3</property>  
   
   
 <property name="maxIdleTime">60</property>  
   
   
 <property name="maxPoolSize">15</property>  
   
   
 <property name="maxStatements">100</property>  
   
   
 <property name="maxStatementsPerConnection"></property>  
   
   
 <property name="numHelperThreads">3</property>  
   
   
 <property name="overrideDefaultUser">root</property>  
   
   
 <property name="overrideDefaultPassword">password</property>  
   
   
 <property name="password"></property>  
   
   
 <property name="preferredTestQuery">select id from test where id=1</property>  
   
   
 <property name="propertyCycle">300</property>  
   
   
 <property name="testConnectionOnCheckout">false</property>  
   
   
 <property name="testConnectionOnCheckin">true</property>  
   
   
 <property name="user">root</property>  
   
   
 <property name="usesTraditionalReflectiveProxies">false</property>

<property name="automaticTestTable">con\_test</property>  
    <property name="checkoutTimeout">30000</property>  
    <property name="idleConnectionTestPeriod">30</property>  
    <property name="initialPoolSize">10</property>  
    <property name="maxIdleTime">30</property>  
    <property name="maxPoolSize">25</property>  
    <property name="minPoolSize">10</property>  
    <property name="maxStatements">0</property>  
    <user-overrides user="swaldman">  
    </user-overrides>  
  </default-config>  
  <named-config name="dumbTestConfig">  
    <property name="maxStatements">200</property>  
    <user-overrides user="poop">  
      <property name="maxStatements">300</property>  
    </user-overrides>  
   </named-config>  
</c3p0-config>
````