Hi !
I'm using Castor and DBCP in my app and I'm having lots of pool exhausted exceptions. I believe that it happens because I have a lot of processing when
showing my app pages. But I'm sure of closing each Castor DB connection after its use. So, I don't see any reason to the exceptions and another strange
thing is that I have this error many times running the app with one single user.
Did you have any hint ? What should I do in this case ? I have to increase the number of connections avaible at the pool ? Should I configure a waiting time ?
MySQL can display a list of processes (connections) running with "show processlist", what type of database are you using?
You must make sure your're closing your connections and if you want to patch Castor you can try out this fix that logs if connections is not closed by the user:
http://bugzilla.exolab.org/show_bug.cgi?id=1499
Of course it would help with some code to look at...
This is my setup for Poolman: <initialConnections>1</initialConnections> <minimumSize>0</minimumSize> <maximumSize>99</maximumSize> <connectionTimeout>3600</connectionTimeout> <skimmerFrequency>120</skimmerFrequency> <userTimeout>100</userTimeout>
I've set the connection to be closed after an hour of inactivity, so at the end of day when things calm down at the site resources are cleaned up.
Stein
----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
