c3p0连接池xml配置文件

MC6058

于 2021-09-23 16:26:58 发布

阅读量237

点赞数

文章标签： xml mysql

本文链接：https://blog.csdn.net/chenzitian6058/article/details/120437639

版权

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
    <!-- This app is massive! -->
    <named-config name="c3p0">
        <property name="driverClass">com.mysql.cj.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/WebServer?serverTimezone=UTC&amp;rewriteBatchedStatements=true
        </property>
        <property name="user">root</property>
        <property name="password">622841chen</property>

        <!-- connector pool configuration-->
        <!--当连接不够且没达到最大时，一次增加5-->
        <property name="acquireIncrement">5</property>
        <!--        初始练级数 -->
        <property name="initialPoolSize">10</property>
        <property name="minPoolSize">10</property>
        <!--        最大链接数量-->
        <property name="maxPoolSize">1000</property>


        <!-- intergalactoApp adopts a different approach to configuring statement caching -->
        <!--        数据库批处理，此部分没用上，但是可以写出来-->
        <property name="maxStatements">50</property>
        <property name="maxStatementsPerConnection">5</property>

    </named-config>
</c3p0-config>