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]
