Managed Threads: 3 Active Threads: 3 Active Tasks: com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@60fc239c(com.mchange.v2.async.ThreadPoolAsynchronousRunner PoolThread-#1) com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@7972c2de(com.mchange.v2.async.ThreadPoolAsynchronousRunner PoolThread-#2) com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@51564046(com.mchange.v2.async.ThreadPoolAsynchronousRunner PoolThread-#0) Pending Tasks: com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@132ffaacom.mchange.v2.resourcepool.BasicResourcePool AcquireTask@d3dcd3 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@6fd88a25com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@c6fa3e8 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@1a36d260com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@49da0b1 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@2fbf9ba5com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@5e3e0d59 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@7237612ccom.mchange.v2.resourcepool.BasicResourcePool AcquireTask@1bc6dff3 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@48770d9dcom.mchange.v2.resourcepool.BasicResourcePool AcquireTask@660d850f com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@2ffaa6e3com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@2eedda8 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@7285238dcom.mchange.v2.resourcepool.BasicResourcePool AcquireTask@782af52f com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@21d9977com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@766a0701 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@2da8db0acom.mchange.v2.resourcepool.BasicResourcePool AcquireTask@284d01d com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@6cbc371bcom.mchange.v2.resourcepool.BasicResourcePool AcquireTask@4ac86782 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@21d3955acom.mchange.v2.resourcepool.BasicResourcePool AcquireTask@573ad45 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@8fa561fcom.mchange.v2.resourcepool.BasicResourcePool AcquireTask@107d4f5 com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@3cc3e8caPoolthreadstacktraces:Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner PoolThread-#1,5,main] java.lang.Thread.sleep(Native Method) com.mchange.v2.resourcepool.BasicResourcePool AcquireTask.run(BasicResourcePool.java:1805)com.mchange.v2.async.ThreadPoolAsynchronousRunner PoolThread.run(ThreadPoolAsynchronousRunner.java:547) Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunnerPoolThread-#2,5,main] java.lang.Thread.sleep(Native Method) com.mchange.v2.resourcepool.BasicResourcePoolAcquireTask.run(BasicResourcePool.java:1805) com.mchange.v2.async.ThreadPoolAsynchronousRunner PoolThread.run(ThreadPoolAsynchronousRunner.java:547)Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner PoolThread-#0,5,main] java.lang.Thread.sleep(Native Method) com.mchange.v2.resourcepool.BasicResourcePool AcquireTask.run(BasicResourcePool.java:1805)com.mchange.v2.async.ThreadPoolAsynchronousRunner PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
08-Mar-2017 14:01:17.385 警告 [com.mchange.v2.async.ThreadPoolAsynchronousRunnerPoolThread-#0] com.mchange.v2.resourcepool.BasicResourcePoolAcquireTask.run com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@51564046–AcquisitionAttemptFailed!!!Clearingpendingacquires.Whiletryingtoacquireaneedednewresource,wefailedtosucceedmorethanthemaximumnumberofallowedacquisitionattempts(30).Lastacquisitionattemptexception:java.sql.SQLException:Nosuitabledriveratjava.sql.DriverManager.getDriver(DriverManager.java:315)atcom.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)atcom.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)atcom.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)atcom.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)atcom.mchange.v2.c3p0.impl.C3P0PooledConnectionPool 1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access 800(BasicResourcePool.java:32)atcom.mchange.v2.resourcepool.BasicResourcePool AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
08-Mar-2017 14:01:17.385 警告 [com.mchange.v2.async.ThreadPoolAsynchronousRunnerPoolThread-#2] com.mchange.v2.resourcepool.BasicResourcePoolAcquireTask.run com.mchange.v2.resourcepool.BasicResourcePool AcquireTask@7972c2de–AcquisitionAttemptFailed!!!Clearingpendingacquires.Whiletryingtoacquireaneedednewresource,wefailedtosucceedmorethanthemaximumnumberofallowedacquisitionattempts(30).Lastacquisitionattemptexception:java.sql.SQLException:Nosuitabledriveratjava.sql.DriverManager.getDriver(DriverManager.java:315)atcom.mchange.v2.c3p0.DriverManagerDataSource.driver(DriverManagerDataSource.java:223)atcom.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:134)atcom.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:182)atcom.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:171)atcom.mchange.v2.c3p0.impl.C3P0PooledConnectionPool 1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:137) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1014) at com.mchange.v2.resourcepool.BasicResourcePool.access 800(BasicResourcePool.java:32)atcom.mchange.v2.resourcepool.BasicResourcePool AcquireTask.run(BasicResourcePool.java:1810) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
数据库连接配置不匹配，c3p0-config.xml例子：
<?xml version='1.0' encoding='UTF-8'?> <c3p0-config> <named-config name="smartcitymvc"> <property name="user">root</property> <property name="password">1234</property> <property name="driverClass">com.mysql.jdbc.Driver</property> <property name="jdbcUrl">jdbc:mysql://localhost:3306/smartcity</property> <property name="acquireIncrement">20</property> <property name="initialPoolSize">30</property> <property name="minPoolSize">20</property> <property name="maxPoolSize">50</property> \ <property name="maxStatements">20</property> <property name="maxStatementsPerConnection">5</property> </named-config> </c3p0-config>