tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Silvio Rainoldi" <ia...@zattix.com>
Subject Re: Losing connection to db with many users
Date Wed, 23 Jul 2008 11:53:58 GMT
I think it's not this the problem... Connection is managed by Hibernate and
I close the connection in all pages...

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

> 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
>
>


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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message