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]
