ITeye博客

c3p0参数试探

east_java · 2009-07-28 21:56 · database · Markdown

数据库最大连接数为20 经常出现最大连接数错误has exceeded the 'max_user_connections' resource (current value: 20)


c3p0.acquireIncrement=3
c3p0.initialPoolSize=3
c3p0.idleConnectionTestPeriod=60
c3p0.minPoolSize=3
c3p0.maxPoolSize=19
c3p0.maxStatements=100
c3p0.numHelperThreads=10
c3p0.maxIdleTime=60

现改下:


c3p0.acquireIncrement=3
c3p0.initialPoolSize=5

#每60秒检查所有连接池中的空闲连接
c3p0.idleConnectionTestPeriod=60
c3p0.minPoolSize=5
c3p0.maxPoolSize=19
c3p0.maxStatements=100
c3p0.numHelperThreads=10
#最大空闲时间,60秒内未使用则连接被丢弃。若为0则永不丢弃
c3p0.maxIdleTime=5

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。