I'm using hibernate wrapped via the spring framework, so all
connections *should* be returned to the pool under all conditions. I
don't use tomcat(6.0.16) connection pools, I have hibernate (via
spring) to use the connection pool directly.
The pool is setup as follows:
jdbc.testOnBorrow=true
jdbc.validationQuery=select 1 + 1
jdbc.maxActive=100
jdbc.maxIdle=10
jdbc.minIdle=0
jdbc.timeBetweenEvictionRunsMillis=-1
jdbc.minEvictableIdleTimeMillis=900000
jdbc.maxWait=15000
These map directly to the dbcp settings.
Cheers,
Ian Long
Chief Software Architect, Opterus Inc.
Email: ian.l...@opterus.com
Phone: 416-840-8495 x666
Mobile: 416-817-9206
Web: http://www.opterus.com
On 12-Mar-09, at 1:45 PM, Caldarale, Charles R wrote:
From: Ian Long [mailto:ian.l...@opterus.com]
Subject: Garbage collection problem and Tomcat
I'm having an issue where a connection pool (apache dbcp) is waiting
forever for a connection, when I see no reason for it to do so.
The usual cause is pool exhaustion, due to improper coding in a
webapp that fails to return connections to the pool under *all*
circumstances.
Nothing else has the lock
Irrelevant.
I googled the problem and found a few other people who had
the issue, and there problem was related to GC.
Highly unlikely; sounds like finger-pointing.
I see the 'from space' is at 99% used, as is PSPermGen object space.
Not true in either case. You've used up 99% of what was *allocated*
for the particular space at this time, not 99% of the maximum.
You're nowhere close to filling up any region of the heap.
Do you think this could be causing my problem?
No.
If you had bothered to tell us the version of Tomcat you're using,
we could have told you the proper documentation to read about how to
use a connection pool.
- Chuck
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE
PROPRIETARY MATERIAL and is thus for use only by the intended
recipient. If you received this in error, please contact the sender
and delete the e-mail and its attachments from all computers.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
