C3P0连接池错误

yonguo

浏览: 245900 次
性别:
来自: 上海

最近访客更多访客>>

hxt1227

paynexss

inclick

wintersun2

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

Ibatis入门

Java JDBC thread iBATIS Bean

Ibatis中关于C3p0连接池的配置如下：

xml 代码

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">

        <property name="driverClass" value="${jdbc.driverClassName}"/>

        <property name="jdbcUrl" value="${jdbc.url}"/>

        <property name="user" value="${jdbc.username}"/>

        <property name="password" value="${jdbc.password}"/>



    <property name="minPoolSize" value="1"/>

        <property name="maxPoolSize" value="20"/>

        <property name="maxIdleTime" value="10"/>

        <property name="acquireIncrement" value="3"/>

        <property name="maxStatements" value="0"/>

        <property name="initialPoolSize" value="20"/>

        <property name="idleConnectionTestPeriod" value="10"/>

</bean>

在执行的时候报如下错误信息：

WARN - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1eeb95
e -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending task
s!
WARN - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@1eeb95
e -- APPARENT DEADLOCK!!! Complete Status:
Managed Threads: 3
Active Threads: 3
Active Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@d43997
(com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@110f85
0 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@11e8d5
c (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
Pending Tasks:
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@d2ad3c

Pool thread stack traces:
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5
,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(Ba
sicResourcePool.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(Ba
sicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run
(ThreadPoolAsynchronousRunner.java:547)
Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5
,main]
java.lang.Thread.sleep(Native Method)
com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(Ba
sicResourcePool.java:1805)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run
(ThreadPoolAsynchronousRunner.java:547)

解决办法：

更改配置文件里的最大连接数和初始化连接数大小：

xml 代码

<property name="maxPoolSize" value="1"/>

<property name="initialPoolSize" value="1"/>

因为数据库的连接数是有限的，每次应用启动C3p0都会占用数据库的连接来填充C3p0的连接池，而当数据库的资源被占光时就会因为无法获得共享资源而报死锁。

分享到：

window.open用法详解(转) | 居中的弹出式窗口

2007-09-05 11:13
浏览 16487
评论(2)
查看更多

2 楼 hehu158 2011-11-18

我试着将我的配置改成楼主的，但是还是报这个警告啊，真不知道应该怎么办啊。

1 楼 axiang_2898 2007-12-05

spring与之应用则也会出现死锁,是不是上面的问题还不清楚!

发表评论

您还没有登录,请您登录后再发表评论