数据库连接配置不匹配

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.BasicResourcePool
AcquireTask.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@51564046AcquisitionAttemptFailed!!!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@7972c2deAcquisitionAttemptFailed!!!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>
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值