users@glassfish.java.net

Re: jdbc-connection-pool settings

From: <glassfish_at_javadesktop.org>
Date: Wed, 18 Jun 2008 06:24:52 PDT

Oh, I am not sure then. It is possible that hibernate uses only one connection at any given time. But,

maxConnectionRequestWait = 4654 is fine (4.5 seconds). This particular request may be due to pool initialization (physical connection(s) creation time for steady-pool), so it is fine.
totalConnectionRequestWait = 15410 is fine since 120 connections are acquired from pool.

The issue here is :
numConnCreated = 45, but maxNumConnFree = 102
and
numConnAcquired = 120 numConnReleased = 110, which means currNumConnUsed has to be 10, but currNumConnUsed = -77 (a negative value !)
[Message sent by forum member 'jr158900' (jr158900)]

http://forums.java.net/jive/thread.jspa?messageID=281026