【C3P0】解决使用c3p0数据库连接池的各种报错警告: Having failed to acquire a resource, com.mchange.v2.resourcepool

最新推荐文章于 2024-06-17 23:36:40 发布
最新推荐文章于 2024-06-17 23:36:40 发布
阅读量4.4k 收藏 19
点赞数 10
分类专栏： C3P0 Mysql 文章标签： java mysql c3p0
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/helloyuanye/article/details/120913457
版权

运行环境
工具： IntelliJ IDEA
java version “1.8.0_261”
MySQL"5.7.19"
在使用IDEA连接c3p0数据库时，导入的四个jar包：
1.mysql-connector-java-5.1.47.jar
2.c3p0-0.9.5.5.jar
3.mchange-commons-java-0.2.20.jar
4.commons-logging-1.2.jar

c3p0-config.xml配置文件如下：

<?xml version="1.0" encoding="UTF-8" ?>
        <c3p0-config>
        <!--
        c3p0的缺省（默认）配置
        如果在代码中"ComboPooledDataSource ds=new ComboPooledDataSource("");"这样写就表示使用的是C3P0的缺省（默认）配置信息来创建数据源-->
        <default-config>
                <property name="driverClass">com.mysql.cj.jdbc.Driver</property>
                <property name="jdbcUrl">jdbc:mysql://localhost:3306/jdbcStudy?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false</property>
                <property name="user">root</property>
                <property name="password">123456</property>

                <property name="acquireIncrement">5</property>
                <property name="initialPoolSize">10</property>
                <property name="minPoolSize">5</property>
                <property name="maxPoolSize">20</property>
        </default-config>




        <!--
        c3p0的命名配置
        如果在代码中"ComboPooledDataSource ds=new ComboPooledDataSource("MySQL");"这样写就表示使用的是name是MySQL的配置信息来创建数据源-->
        <name-config name="MySQL">
        <property name="driverClass">com.mysql.cj.jdbc.Driver</property>
        <property name="jdbcUrl">jdbc:mysql://localhost:3306/jdbcStudy?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=UTC</property>
        <property name="user">root</property>
        <property name="password">123456</property>

        <property name="acquireIncrement">5</property>
        <property name="initialPoolSize">10</property>
        <property name="minPoolSize">5</property>
        <property name="maxPoolSize">20</property>
        </name-config>
        </c3p0-config>

测试代码（TestC3P0）：

package com.yuanye.lesson05;

import com.yuanye.lesson05.utils.JdbcUtils_C3P0;


import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

public class TestC3P0 {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement st = null;

        try {
            conn = JdbcUtils_C3P0.getConnection();//原来是自己实现的，现在用别人实现的

            //区别
            //使用？占位符代替参数
            String sql = "insert into users(id,`name`,`password`,`email`,`birthday`) values(?,?,?,?,?)";

            st = conn.prepareStatement(sql);//()需要参数，预编译SQL,先写sql，然后不执行

            //手动给参数赋值
            st.setInt(1,6);//给id赋值
            st.setString(2,"yuanye4");
            st.setString(3,"123456");
            st.setString(4,"123456@qq.com");
            //注意点：sql.Date  数据库用的
            //      util.Date  JAVA用的  new Date().getTime()获得时间戳
            st.setDate(5,new java.sql.Date(new java.util.Date().getTime()));

            //执行
            int i = st.executeUpdate();
            if (i>0){
                System.out.println("插入成功！");
            }
        } catch (SQLException throwables) {
            throwables.printStackTrace();
        }finally {
            JdbcUtils_C3P0.release(conn,st,null);
        }
    }
}

执行成功结果如下：

D:\Java\jdk1.8.0_261\bin\java.exe "-javaagent:D:\IntelliJ IDEA Community Edition 2021.1\lib\idea_rt.jar=8451:D:\IntelliJ IDEA Community Edition 2021.1\bin" -Dfile.encoding=UTF-8 -classpath D:\java\jdk1.8.0_261\jre\lib\charsets.jar;D:\java\jdk1.8.0_261\jre\lib\deploy.jar;D:\java\jdk1.8.0_261\jre\lib\ext\access-bridge-64.jar;D:\java\jdk1.8.0_261\jre\lib\ext\cldrdata.jar;D:\java\jdk1.8.0_261\jre\lib\ext\dnsns.jar;D:\java\jdk1.8.0_261\jre\lib\ext\jaccess.jar;D:\java\jdk1.8.0_261\jre\lib\ext\jfxrt.jar;D:\java\jdk1.8.0_261\jre\lib\ext\localedata.jar;D:\java\jdk1.8.0_261\jre\lib\ext\nashorn.jar;D:\java\jdk1.8.0_261\jre\lib\ext\sunec.jar;D:\java\jdk1.8.0_261\jre\lib\ext\sunjce_provider.jar;D:\java\jdk1.8.0_261\jre\lib\ext\sunmscapi.jar;D:\java\jdk1.8.0_261\jre\lib\ext\sunpkcs11.jar;D:\java\jdk1.8.0_261\jre\lib\ext\zipfs.jar;D:\java\jdk1.8.0_261\jre\lib\javaws.jar;D:\java\jdk1.8.0_261\jre\lib\jce.jar;D:\java\jdk1.8.0_261\jre\lib\jfr.jar;D:\java\jdk1.8.0_261\jre\lib\jfxswt.jar;D:\java\jdk1.8.0_261\jre\lib\jsse.jar;D:\java\jdk1.8.0_261\jre\lib\management-agent.jar;D:\java\jdk1.8.0_261\jre\lib\plugin.jar;D:\java\jdk1.8.0_261\jre\lib\resources.jar;D:\java\jdk1.8.0_261\jre\lib\rt.jar;D:\java练习\jdbcStudy\out\production\jdbcStudy;D:\java练习\jdbcStudy\lib\c3p0-0.9.5.5.jar;D:\java练习\jdbcStudy\lib\commons-dbcp2-2.9.0.jar;D:\java练习\jdbcStudy\lib\commons-logging-1.2.jar;D:\java练习\jdbcStudy\lib\commons-pool2-2.11.1.jar;D:\java练习\jdbcStudy\lib\mchange-commons-java-0.2.20.jar;D:\java练习\jdbcStudy\lib\mysql-connector-java-5.1.47.jar com.yuanye.lesson05.TestC3P0
十月 22, 2021 9:12:49 下午 com.mchange.v2.log.MLog 
信息: MLog clients using java 1.4+ standard logging.
十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.C3P0Registry 
信息: Initializing c3p0-0.9.5.5 [built 11-December-2019 22:07:46 -0800; debug? true; trace: 10]
十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.cfg.C3P0Config 
警告: named-config with name 'MySQL' does not exist. Using default-config.
十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.cfg.C3P0Config 
警告: named-config with name 'MySQL' does not exist. Using default-config extensions.
十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource 
信息: Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 5, acquireRetryAttempts -> 30, acquireRetryDelay -> 1000, autoCommitOnClose -> false, automaticTestTable -> null, breakAfterAcquireFailure -> false, checkoutTimeout -> 0, connectionCustomizerClassName -> null, connectionTesterClassName -> com.mchange.v2.c3p0.impl.DefaultConnectionTester, contextClassLoaderSource -> caller, dataSourceName -> MySQL, debugUnreturnedConnectionStackTraces -> false, description -> null, driverClass -> com.mysql.cj.jdbc.Driver, extensions -> {}, factoryClassLocation -> null, forceIgnoreUnresolvedTransactions -> false, forceSynchronousCheckins -> false, forceUseNamedDriverClass -> false, identityToken -> 2rvxttak1anfh8q1k3ken4|77a567e1, idleConnectionTestPeriod -> 0, initialPoolSize -> 10, jdbcUrl -> jdbc:mysql://localhost:3306/jdbcStudy?useUnicode=true&characterEncoding=utf8&useSSL=false, maxAdministrativeTaskTime -> 0, maxConnectionAge -> 0, maxIdleTime -> 0, maxIdleTimeExcessConnections -> 0, maxPoolSize -> 20, maxStatements -> 0, maxStatementsPerConnection -> 0, minPoolSize -> 5, numHelperThreads -> 3, preferredTestQuery -> null, privilegeSpawnedThreads -> false, properties -> {user=******, password=******}, propertyCycle -> 0, statementCacheNumDeferredCloseThreads -> 0, testConnectionOnCheckin -> false, testConnectionOnCheckout -> false, unreturnedConnectionTimeout -> 0, userOverrides -> {}, usesTraditionalReflectiveProxies -> false ]
十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

十月 22, 2021 9:12:50 下午 com.mchange.v2.c3p0.DriverManagerDataSource 
警告: Could not load driverClass com.mysql.cj.jdbc.Driver
java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver
	at java.net.URLClassLoader.findClass(URLClassLoader.java:382)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:418)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:355)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:351)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:264)
	at com.mchange.v2.c3p0.DriverManagerDataSource.ensureDriverLoaded(DriverManagerDataSource.java:143)
	at com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:173)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:220)
	at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1176)
	at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1163)
	at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44)
	at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1908)
	at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696)

插入成功！

Process finished with exit code 0

结论：

这是我经过各种报错后查阅各种资料和广大网友的相关问题后总结出来的MySQL8之后连接C3P0的正确配置文件和代码。
如果网友们有相关问题，一定要检查开发环境和MySQL不同版本之间的兼容性。
基本上都是以下

        <property name="jdbcUrl">jdbc:mysql://localhost:3306/jdbcStudy?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=UTC</property>

这一段代码的useSSL问题和时区问题！
如果出现Could not initialize class 那么还要导入一个文章开头所提到的第四个包：commons-logging-1.2.jar 的依赖！

helloyuanye
关注
  • 10
    点赞
  • 踩
  • 19
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
mysql时区错误_mysql的时区错误的解决办法
weixin_30825953的博客
02-11 341
十二月 02, 2018 9:16:19 下午 com.mchange.v2.resourcepool.BasicResourcePool警告: Having failed to acquire a resource, com.mchange.v2.resourcepool.BasicResourcePool@3fad3f72 is interrupting all Threads waiting...
集成C3P0连接池后控制台狂抛com.mchange.v2.c3p0.SQLWarnings错误解决方案
ahzsg1314的专栏
11-27 7473
集成C3P0连接池后控制台狂抛com.mchange.v2.c3p0.SQLWarnings错误解决方案
springboot搭建环境下启动eureka失败
最新发布
m0_46649210的博客
06-17 498
仔细查看报错信息会发现，这个报错是由于pom文件引入FastJson这个依赖造成的，由于FastJsonAutoDiscoverable没有被定义或者继承所以程序报错，最简单方法是先注释掉依赖。jdk版本：graalvm-jdk-21.0.3+7.1。
万恶的c3p0连接池bug
weixin_43710268的博客
11-10 1411
之前在windows上写过一个项目,使用了spring ,mybatis和c3p0连接池连接数据库,本来在windows的tomcat上运行是正常的,后来我放到linux上,就爆出了这样一个错误: 十一月 10, 2020 9:21:49 下午 com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource 信息: Initializing c3p0 pool… com.mchange.v2.c3p0.ComboPooledDataSource [ acquir
C3P0连接池连接异常错误解决
热门推荐
lddongyu
07-01 2万+
转自：http://hi.baidu.com/zhenuu/blog/item/b91661385ca23d2a96ddd871.html
com.mchange.v2.c3p0.combopooleddatasource配置的那些破事
weixin_34100227的博客
01-06 661
为什么80%的码农都做不了架构师？>>> ...
c3p0-0.9.5.2及配置文件和mysql8驱动包.zip
07-04
在Java开发中，数据库连接管理是一项重要的任务，为了...总之，这个压缩包提供了一个完整的解决方案，帮助开发者快速集成c3p0连接池并连接到MySQL 8.x数据库，无需自己去分别下载和配置各个组件，大大简化了开发流程。
hibernate c3p0 数据库连接池参数详解.txt
08-14
### Hibernate C3P0 数据库连接池参数详解 在企业级应用开发中，数据库连接池技术扮演着极其重要的角色，它能显著提高系统的性能并优化资源管理。Hibernate 作为 Java 领域中最流行的 ORM（对象关系映射）框架之一...
HibernateC3P0 数据库连接池架包.rar
07-19
《深入理解HibernateC3P0数据库连接池》 在当今的Web应用开发中，数据库连接管理是不可或缺的一部分，而数据库连接池技术则是优化这一过程的关键。HibernateC3P0作为一款常用的开源数据库连接池，其高效、稳定的...
Java使用C3P0连接MySQL数据库查询
09-27
在这个场景中，我们将深入探讨如何使用C3P0连接池来与MySQL数据库进行交互，并结合log4j进行日志记录。 首先，要使用C3P0，你需要在项目中引入相应的依赖。在Maven项目中，可以在pom.xml文件中添加以下依赖： ```...
C3P0连接池配置需要的jar包
01-26
C3P0连接池是Java应用中常用的数据库连接池组件，它允许程序在不关闭物理连接的情况下，管理和重用数据库连接，从而提高了应用程序的性能和效率。C3P0库依赖于其他几个JAR包来实现其功能，包括`c3p0-0.9.2.1.jar`、`...
c3p0连接池常用错误解决方案
qq_42738387的博客
10-01 1749
不知不觉大三了，又忘记写博客这么久了。 这次写一下最近的有关使用Myeclipse8.0版本去使用c3p0连接池的经验。 本次使用连接池连接数据库弄了一个比较经典的例子，转账；不过这次不是写怎么转账的，相信这个东西随便都能写的出。这次写的是关于在使用过程中遇到的问题，以及解决。 我数据库是mysql8.0. 连接池用的c3p0 0.9.1.2。我没有创建 一般遇到的c3p0-config.xml配置文件。我使用的是Spring的ApplictionXml在这里搭建c3p0. ApplicationXml配置
c3p0数据库连接池无法连接数据库—错误使用了username关键字
该怎么解释？我懒得解释
02-25 9564
一、问题描述 上篇博客说到了关于maven无法下载依赖jar包的问题，这篇博客再说一下关于在本个项目中遇到的关于使用C3P0连接池连接数据库的问题，真心很奇葩，在此，也请大家引起注意。首先看我的项目基本结构： 已确定的情况：相关jar包均已正确下载，路径跳转正常，jdbc所配置的内容，完全正确。相关数据库连接池和spring的整合也都完全正确，但事实就是没法儿连接上！ 解决了
C3P0连接池启动时 APPARENT DEADLOCK!!! 错误
AI开源工具分享
06-24 6931
在Windows平台下运行正常的应用部署到Linux服务器上之后，一直报错：com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@bbd1b —APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks! 查了好多论坛，发现
（已解决） Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ acquireIncrement -> 3, a
PizAn的博客
12-25 1万+
第一次用java17记录运行ruoyi-vue-plus5.X版本
宁波阿成的博客
02-26 570
第一次用java17记录运行ruoyi-vue-plus5.X版本
c3p0数据库连接池死锁问题
weixin_34199335的博客
09-02 259
项目进行压力测试的时候，运行大概1小时候，后台抛出以下异常：   Java代码   Nov 9, 2012 1:41:59 AM com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run   WARNING: com.mchange.v2.async.ThreadPoolAsynchrono...
maven冲突解决
weixin_39330505的博客
08-22 798
开发中难免遇到maven依赖冲突，MAVEN构建会报错，例如:   Found in:     commons-logging:commons-logging:jar:1.1:compile     org.slf4j:jcl-over-slf4j:jar:1.7.21:compile   Duplicate classes:     org/apache/commons/loggi
c3p0 概率性报错：com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool cannot acquire a new resource -- the factory or source appears to be down.
06-13
这个错误通常是由于连接池中的连接资源被占用而无法获取新的连接资源，可能是因为连接资源的释放不及时或是连接池配置不合理导致的。你可以尝试以下几种方式来解决这个问题： 1. 调整连接池的配置，增加连接池中的最大连接数。 2. 检查程序中对于连接资源的使用，确保连接资源使用后及时释放。 3. 修改数据库的配置，增加数据库的最大连接数。 4. 检查数据库是否正常运行，是否出现了异常或者宕机等情况。 5. 考虑使用其他连接池，比如 Druid 等。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值