; 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:
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
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
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.
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,
>
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
Are you getting the connection anew after restarting the server? It looks
like you have this case:
T0 Connection x = Datasource.getConnection()
T1 Do some stuff
T2 Shutdown / restart MySQL
T3 x.prepareStatement() or other stuff
... FAIL
The connection pool will only renew the
