users@glassfish.java.net

Re: Connection Pool Issues

From: Marina Vatkina <Marina.Vatkina_at_Sun.COM>
Date: Fri, 06 Feb 2009 13:21:12 -0800

You can enable connection reclaim, but a better solution would be to close
connections after each use instead of keeping them open.

Regards,
-marina

Chopra, Rishi wrote:
> Hi,
> I have an issue with my web application where once the maximum
> connections are being used somehow by the users, httpWorkerThreads keeps
> requesting the thread pool for the connection from the connection pool.
> Hence the exceptions come like '_Cannot allocate more connections_'
> appear in the logs after which the application become impossible to use
> unless glassfish is restarted.
>
> Could you please advise if say some other connections become idle during
> this time why glassfish does not the reclaim the connection and give it
> to another user request (httpWorkerThread...)
>
> Thanks & Regards,
> Rishi Chopra.
>
> http://www.bgcpartners.com
> CONFIDENTIAL: This e-mail has been sent to you by one of the BGC
> entities (collectively BGC) listed at the following link:
> http://www.bgcpartners.com/legal/disclaimers/index.html#email_disclaimer
> The link contains company and FSA registration numbers. This e-mail,
> including its contents and attachments, if any, are confidential. If you
> are not the named recipient please notify the sender and immediately
> delete it. You may not disseminate, distribute, or forward this e-mail
> message or disclose its contents to anybody else. Copyright and any
> other intellectual property rights in its contents are the sole property
> of BGC and its affiliates. E-mail transmission cannot be guaranteed to
> be secure or error-free. The sender therefore does not accept liability
> for any errors or omissions in the contents of this message which arise
> as a result of e-mail transmission. If verification is required please
> request a hard-copy version. Although we routinely screen for viruses,
> addressees should check this e-mail and any attachments for viruses. We
> make no representation or warranty as to the absence of viruses in this
> e-mail or any attachments. Please note that to ensure regulatory
> compliance and for the protection of our customers and business, we may
> monitor and read e-mails sent to and from our server(s). The registered
> offices of the BGC entities are at 1 Churchill Place, London, E14 5RD.
> For any issues arising from this email please reply to the sender. The
> FSA register appears at http://www.fsa.gov.uk/register/. The FSA
> regulates the financial services industry in the United Kingdom and is
> located at 25 The North Colonnade, Canary Wharf, London, E14 5HS.
>