配置C3P0连接池，项目记录

最新推荐文章于 2024-04-21 22:54:31 发布

门前大乔吓

最新推荐文章于 2024-04-21 22:54:31 发布

阅读量339

点赞数

文章标签： c3p0 spring

本文链接：https://blog.csdn.net/qq_37301964/article/details/78328583

版权

本篇完全为项目中摘抄下来的，仅为本人记录之用。外人看到，仅做参考。

这里是配合spring使用的。下面是spring的配置文件applicationContext.xml里面的摘录。

<!-- 数据源定义,使用c3p0 连接池 -->
    <bean id="originDataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
          destroy-method="close">
        <property name="driverClass">
            <value>${jdbc.driverClassName}</value>
        </property>
        <property name="jdbcUrl">
            <value>${jdbc.url}</value>
        </property>
        <property name="user">
            <value>${jdbc.username}</value>
        </property>
        <property name="password">
            <value>${jdbc.password}</value>
        </property>
        <property name="acquireIncrement">
            <value>${c3p0.acquireIncrement}</value>
        </property>
        <property name="initialPoolSize">
            <value>${c3p0.initialPoolSize}</value>
        </property>
        <property name="minPoolSize">
            <value>${c3p0.minPoolSize}</value>
        </property>
        <property name="maxPoolSize">
            <value>${c3p0.maxPoolSize}</value>
        </property>
        <property name="maxIdleTime">
            <value>${c3p0.maxIdleTime}</value>
        </property>
        <property name="idleConnectionTestPeriod">
            <value>${c3p0.idleConnectionTestPeriod}</value>
        </property>
        <property name="maxStatements">
            <value>${c3p0.maxStatements}</value>
        </property>
        <property name="numHelperThreads">
            <value>${c3p0.numHelperThreads}</value>
        </property>
    </bean>
    <bean id="exceptionResolver" class="com.sunesoft.titan.exeption.TitanExceptionResolver"></bean>
    <context:property-placeholder location="classpath:jdbc.properties"/>
    <bean id="dataSource" class="org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy"
          p:targetDataSource-ref="originDataSource"/>

下面是配置文件jdbc.properties的内容对应上面的引用。

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://120.xx.xx.xx:3306/XXXXXX?useUnicode=true&characterEncoding=UTF-8
hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
jdbc.username=xxxx
jdbc.password=xxxx
c3p0.acquireIncrement=3
c3p0.initialPoolSize=3
c3p0.idleConnectionTestPeriod=900
c3p0.minPoolSize=3
c3p0.maxPoolSize=25
c3p0.maxStatements=0
c3p0.numHelperThreads=100
c3p0.maxIdleTime=600