Connection pool for high throughput application issue
918852Feb 21 2012 — edited Feb 21 2012I used C3P0 connection pool(and Oracle 11) to now but get not stable behavor. I test in very kinde of environment and improvment data base options. I found today Tomcate 7 jdbc connection pool released and get it. Do anyone use it and get better performance than C3p0? (I also test boncp connection pool)
My application is very high load. My problems are:
1. after pass a hour connection pool throws "Can't Open Connection" exception.
2. sometimes I get this exception "Attempted to use a closed or broken resource" pool and when restart my connection pool(by its mbean) problem fixed
My C3P0 parameters are:
initialPoolSize = 1
minPoolSize=1
maxPoolSize = 50
maxIdleTime = 20000
debugUnreturnedConnectionStackTraces = true
propertyCycle =60
acquireRetryDelay =1000
maxConnectionAge =0
checkoutTimeout =5000
acquireIncrement =1
numHelperThreads =5
acquireRetryAttempts =1
unreturnedConnectionTimeout =90
breakAfterAcquireFailure =false
I also test this parameters with serveral value but dont' perceptible changes.