I think it's not this the problem... Connection is managed by Hibernate and I close the connection in all pages...
2008/7/23 <[EMAIL PROTECTED]>: > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Silvio > Rainoldi > Sent: 23 July 2008 12:05 > To: Tomcat Users List; [EMAIL PROTECTED] > Subject: Re: Losing connection to db with many users > > Ehm.... no... :S > how can I make that? > > Thanks > > 2008/7/23 <[EMAIL PROTECTED]>: > > > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > > -- > Silvio Rainoldi > Via Rinaldo Simen 6 > 6648 Minusio, Switzerland > tel: +41 (0)76 566 03 90 > mail: [EMAIL PROTECTED] > > > *********************************************************************** > 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: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- Silvio Rainoldi Via Rinaldo Simen 6 6648 Minusio, Switzerland tel: +41 (0)76 566 03 90 mail: [EMAIL PROTECTED]