Hibernate配置C3P0连接池

柔情只为你懂 2022-05-16 03:51 332阅读 0赞

引入C3PO包

![659572-20160622143941031-761285241.png][]

在hibernate.cfg.xml文件中配置：

<property name="hibernate.connection.provider_class">org.hibernate.c3p0.internal.C3P0ConnectionProvider</property>
    
    <property name="hibernate.c3p0.min_size">5</property>
    
    <property name="hibernate.c3p0.max_size">20</property>
    
    <property name="hibernate.c3p0.timeout">120</property>
    
    <property name="hibernate.c3p0.idle_test_period">3000</property>

其它配置：

<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>
    在Hibernate（spring管理）中的配置：
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
    <property name="driverClass"><value>oracle.jdbc.driver.OracleDriver</value></property>
    <property name="jdbcUrl"><value>jdbc:oracle:thin:@localhost:1521:Test</value></property>
    <property name="user"><value>Kay</value></property>
    <property name="password"><value>root</value></property>
    
    <property name="minPoolSize" value="10" />
    
    <property name="maxPoolSize" value="100" />
    
    <property name="maxIdleTime" value="1800" />
    
    <property name="acquireIncrement" value="3" />
    <property name="maxStatements" value="1000" />
    <property name="initialPoolSize" value="10" />
    
    <property name="idleConnectionTestPeriod" value="60" />
    
    <property name="acquireRetryAttempts" value="30" />
    <property name="breakAfterAcquireFailure" value="true" />
    <property name="testConnectionOnCheckout" value="false" />
    </bean>
    编辑本段相关信息连接池配置（以Hibernate为例）
    ###########################
    ### C3P0 Connection Pool###
    ###########################
    #hibernate.c3p0.max_size 2
    #hibernate.c3p0.min_size 2
    #hibernate.c3p0.timeout 5000
    #hibernate.c3p0.max_statements 100
    #hibernate.c3p0.idle_test_period 3000
    #hibernate.c3p0.acquire_increment 2
    #hibernate.c3p0.validate false
    在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>

[659572-20160622143941031-761285241.png]: /images/20220516/17e4538d17ff4d3093d444201aa1e265.png