Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Reply-To: <robert.purvis@nhs.net>
From: <robert.purvis@nhs.net>
To: "'Tomcat Users List'" <users@tomcat.apache.org>
References: <c4594ad70807230306mc1cf3b9nfe76b7914340cec1@mail.gmail.com>
	<001e01c8ecb3$1b355400$bd15a8c0@npfit.nhs.uk>
	<c4594ad70807230405x5036cd01l6d784e7126aa3e4a@mail.gmail.com>
Subject: RE: Losing connection to db with many users
Date: Wed, 23 Jul 2008 12:48:41 +0100
Message-ID: <002901c8ecba$0d9af370$bd15a8c0@npfit.nhs.uk>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Thread-Index: Acjst8p2aP2fjUBkSKSGP2iES/DrbQAAgaCQ
In-Reply-To: <c4594ad70807230405x5036cd01l6d784e7126aa3e4a@mail.gmail.com>
Content-Transfer-Encoding: 7bit

I do not know about c3p0, I just know that with the connection pools we use,
you must return a connection to the pool once you are finished with it
because our pools have a limit on the number of connections that can be
created in the pool. This stops the database getting too many requests.


Rob

-----Original Message-----
From: ianaz90@gmail.com [mailto:ianaz90@gmail.com] On Behalf Of Silvio
Rainoldi
Sent: 23 July 2008 12:05
To: Tomcat Users List; robert.purvis@nhs.net
Subject: Re: Losing connection to db with many users

Ehm.... no... :S
how can I make that?

Thanks

2008/7/23 <robert.purvis@nhs.net>:

> Are the connections being returned to the pool after use? If they are 
> not then your application could quickly run out of connections.
>
>
> Rob
>
> -----Original Message-----
> From: ianaz90@gmail.com [mailto:ianaz90@gmail.com] On Behalf Of Silvio 
> Rainoldi
> Sent: 23 July 2008 11:07
> To: users@tomcat.apache.org
> Subject: Losing connection to db with many users
>
> Hi all,
> I'm using tomcat 6 + mysql + c3p0 connection pools + hibernate.
> If i test my web application with Apache JMeter simulating 100 users
> (threads?!) in a page, after 5-30 seconds i will lose the connection to
db.
> If I redeploy the application it work again... In the tomcat manager I 
> see 15'000/18'000 sessions :S Please help me and sorry for my bad 
> english
>
>
> **********************************************************************
> * This  message  may  contain  confidential and  privileged  
> information.
> If you  are not the  intended recipient  you should not  disclose, 
> copy or distribute information in this e-mail or take any action in 
> reliance on its contents.  To do so is strictly  prohibited and may be
unlawful.
> Please  inform  the  sender that  this  message has  gone astray 
> before deleting it.  Thank you.
>
> 2008 marks the 60th anniversary of the NHS.  It's an opportunity to 
> pay tribute to the NHS staff and volunteers who help shape the 
> service, and celebrate their achievements.
>
> If you work for the NHS  and  would like  an NHSmail  email account, 
> go
> to: www.connectingforhealth.nhs.uk/nhsmail
> **********************************************************************
> *
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, 
> e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>


--
Silvio Rainoldi
Via Rinaldo Simen 6
6648 Minusio, Switzerland
tel: +41 (0)76 566 03 90
mail: ianaz@zattix.com


***********************************************************************
This  message  may  contain  confidential and  privileged  information.
If you  are not the  intended recipient  you should not  disclose, copy
or distribute information in this e-mail or take any action in reliance
on its contents.  To do so is strictly  prohibited and may be unlawful.
Please  inform  the  sender that  this  message has  gone astray before
deleting it.  Thank you.

2008 marks the 60th anniversary of the NHS.  It's an opportunity to pay
tribute to the NHS staff and volunteers who help shape the service, and
celebrate their achievements.

If you work for the NHS  and  would like  an NHSmail  email account, go
to: www.connectingforhealth.nhs.uk/nhsmail
***********************************************************************


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org