RE: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted

2006-07-24 Thread Seetha Rao
; for every database >operation? > >Thanks again for your guidance, >Seetha > > >-Original Message- >From: Christopher Schultz [mailto:[EMAIL PROTECTED] >Sent: Sunday, July 23, 2006 8:04 PM >To: [EMAIL PROTECTED] >Cc: Tomcat Users List; [EMAIL PROTECTED] >Subject:

Re: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted

2006-07-24 Thread David Smith
nday, July 23, 2006 8:04 PM To: [EMAIL PROTECTED] Cc: Tomcat Users List; [EMAIL PROTECTED] Subject: Re: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted Seetha, To answer Tim's question, we are not explicitly closing connection and statement o

RE: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted

2006-07-24 Thread Seetha Rao
t Users List; [EMAIL PROTECTED] Subject: Re: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted Seetha, > To answer Tim's question, we are not explicitly closing connection > and statement objects as the context xml has these resour

Re: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted

2006-07-23 Thread Christopher Schultz
Seetha, > To answer Tim's question, we are not explicitly closing connection > and statement objects as the context xml has these resource parameters. > > removeAbandoned="true" > removeAbandonedTimeout="60" > logAbandoned="true" This probably means that you are leaking every single connection.

RE: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted

2006-07-23 Thread Seetha Rao
ons. Thanks Seetha -Original Message- From: Christopher Schultz [mailto:[EMAIL PROTECTED] Sent: Friday, July 21, 2006 6:09 PM To: Tomcat Users List Cc: [EMAIL PROTECTED] Subject: Re: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted Seetha, >

Re: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted

2006-07-21 Thread Christopher Schultz
Seetha, > Are you getting the connection anew after restarting the server? It looks > like you have this case: > > T0Connection x = Datasource.getConnection() > T1Do some stuff > T2Shutdown / restart MySQL > T3x.prepareStatement() or other stuff > ... FAIL > > The connection poo

RE: Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted

2006-07-20 Thread Tim Lucia
t Users List > Subject: Tomcat fails to refresh connections when mySQL server on linux is > shutdown and restarted > > Hi, > > We are doing a test where mySQL server goes down when user is accessing a > webapplication. > We have setup tomcat with the required parameters for

Tomcat fails to refresh connections when mySQL server on linux is shutdown and restarted

2006-07-20 Thread Seetha Rao
Hi, We are doing a test where mySQL server goes down when user is accessing a webapplication. We have setup tomcat with the required parameters for DBCP to handle such a case. It works fine in a set up where Tomcat and mySQL are on the same windows machine. But in a setup where Tomcat is on Window