C3p0配置详解

深碍√TFBOYSˉ_ 2022-07-14 06:18 214阅读 0赞

<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>
    在hibernate.cfg.xml文件里面加入如下的配置：
    　　
    　　<property name="hibernate.c3p0.max_size">20</property>
    　　
    　　<property name="hibernate.c3p0.min_size">5</property>
    　　
    　　<property name="hibernate.c3p0.timeout">120</property>
    　　
    　　<property name="hibernate.c3p0.max_statements">100</property>
    　　
    　　<property name="hibernate.c3p0.idle_test_period">120</property>
    　　
    　　<property name="hibernate.c3p0.acquire_increment">2</property>
    　　
    　　<property name="hibernate.c3p0.validate">true</property>
    　　完整示例如下（hibernate.properties）：
    　　hibernate.connection.driver_class = org.postgresql.Driver
    　　hibernate.connection.url = jdbc:postgresql://localhost/mydatabase
    　　hibernate.connection.username = myuser
    　　hibernate.connection.password = secret
    　　hibernate.c3p0.min_size=5
    　　hibernate.c3p0.max_size=20
    　　hibernate.c3p0.timeout=1800
    　　hibernate.c3p0.max_statements=50
    　　hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect
    注：Hibernate除了期自身的连接池、C3PO连接池以外，还可以使用dbcp包的连接池功能