You don't really need to know, when the user leaves your page, because the app holds the connection only while processing a request. I'd enable JMX and have a close look at the connection pool and at the threads-tab. Possibly, there's a condition which leads to a blocked request-processor-thread holding on for a connection forever. You could also try the logAbandonedConnection-Feature of DBCP ...
hth, Marcus > -----Original Message----- > From: Henry Tong [mailto:[EMAIL PROTECTED] > Sent: Friday, January 26, 2007 8:36 AM > To: Tapestry users > Subject: Re: Cannot get a connection, pool exhausted > > Hi, > > any idea how to release connection when user close the web page? > > Yours Sincerely, > Henry Tong > > On 1/26/07, Jesse Kuhnert <[EMAIL PROTECTED]> wrote: > > > > Allow only one connection in your connection pool and hit the app > > until you find what section freezes / stops working... > > > > On 1/25/07, Henry Tong <[EMAIL PROTECTED]> wrote: > > > Hi, > > > > > > Our team are developing website using tapestry 4.1, > honeycomb 0.3.3, > > hibernate > > > 3.2.0.cr4, hivemind, DBCP 1.2.1 on Tomcat 4.1 and MySQL 4.1. The > > applications > > > run smoothly and suddenly throws exception one week later. The > > > exception > > is > > > org.apache.commons.dbcp.SQLNestedException - Cannot get a > > > connection, > > pool > > > exhausted. > > > > > > The hibernate Daos only find data but not save data at > this moment. > > > Any > > idea to > > > prevent this from happening? > > > > > > Thanks in advance for your Assistance. > > > > > > Yours Sincerely, > > > Henry Tong > > > > > > > > > > -------------------------------------------------------------------- > > > - To unsubscribe, e-mail: [EMAIL PROTECTED] > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > > > > > > -- > > Jesse Kuhnert > > Tapestry/Dojo team member/developer > > > > Open source based consulting work centered around > > dojo/tapestry/tacos/hivemind. http://blog.opencomponentry.com > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
