【c3p0】报错：Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement...

最新推荐文章于 2023-08-25 15:52:23 发布

Sincle_z

最新推荐文章于 2023-08-25 15:52:23 发布

阅读量1.6w

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： c3p0 数据库连接池 ComboPooledDataSourc

本文链接：https://blog.youkuaiyun.com/zzz1192993261/article/details/66478439

在配置并使用c3p0数据库连接池时遇到初始化错误及'Too many connections'异常。通过分析，问题出在频繁创建ComboPooledDataSource实例上。采用单例模式来创建和管理连接池，可以有效解决资源消耗过大和连接数过多的问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

按照书上的指导配置c3p0，但是运行不成功

一开始运行：

信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, dataSourceName -> 1hgeby99n2wpirj7phm07|69847c5d, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.jdbc.Driver, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, identityToken -> 1hgeby99n2wpirj7phm07|69847c5d, idleConnectionTestPeriod ->

然后我刷新了十几次，报如下异常了：

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connectio