C3P0连接池参数详解

系统管理员 2022-05-28 01:21 246阅读 0赞

<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>