【c3p0连接池出现死循环 _数据库】

c3p0连接池出现死循环

我也踩过这个坑( 1 )

已统计您的踩坑,无需重复点击

回答(1)

数据库

详细描述

错误截图

package test;

import com.mchange.v2.c3p0.ComboPooledDataSource;
import org.apache.log4j.Logger;

import java.sql.SQLException;
import java.sql.Statement;

public class Hello2 {
    public static void main(String[] args) {
        Logger logger = Logger.getLogger("log4j.properties");
        ComboPooledDataSource dataSource = null;
        Statement st = null;
        try {

dataSource = new ComboPooledDataSource();
                st = dataSource.getConnection().createStatement();
                int i = st.executeUpdate("INSERT INTO user (name,age,gender) VALUES('haiqing',22,'men')");

} catch (SQLException e) {
            logger.error("捕获异常", e);
        } finally {
            try {
                if (st != null) {
                    st.close();
                    dataSource.getConnection().close();
                    logger.info("关闭连接");
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }

}
    }
}

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
    <named-config name="mysql">
        <property name="user">root</property>
        <property name="password">123456</property>
        <property name="driverClass">com.mysql.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/lianxi?characterEncoding=utf8</property>
        
        
        <property name="acquireIncrement">20</property>
        
        <property name="initialPoolSize">20</property>
        
        <property name="minPoolSize">10</property>
        
        <property name="maxPoolSize">50</property>
        
        
        <property name="maxStatementsPerConnection">0</property>
    </named-config>
</c3p0-config>

编辑于2025-04-19

时间排序

热门排序

[散修弟子]JAVA-7222
0

你这是一直再循环里面创建链接对象，所有直到资源消耗完。

查看全部>

编辑于2019-01-12

去第页