Re: Testing for con.close()

2004-07-10 Thread Peng Tuck Kwok
Hi, 
Usually I call con.close() in the final block. There is a mention of
this here :
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html#Common%20Problems



On Sat, 10 Jul 2004 10:54:31 +0530, Shailender Jain
<[EMAIL PROTECTED]> wrote:
> Hi,
> 
> I have implemented the connection pooling provided by Struts for
> developing my application.
> 
> The application after going live gets hang quite frequently.
> The problem may be related to connection not getting closed for some
> transactions.
> 
> All the transactions takes atleast 1 minute to complete.
> 
> I assume that the user might be pressing the "STOP" button of the
> browser before the transaction gets completed.
> Due to this although we take the connection from the pool but not able
> to return back as the last lines of the code are
> not reached. I think  that if i had written con.close() in the finally
> block then this problem would have not come.
> 
> Is there any way by which i can specify in the struts config .xml to
> close the connection which are not active or not doing anything.
> 
> Regards
> Shailender Jain
> 
>

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



Testing for con.close()

2004-07-09 Thread Shailender Jain
Hi,

I have implemented the connection pooling provided by Struts for
developing my application.

The application after going live gets hang quite frequently.
The problem may be related to connection not getting closed for some
transactions.

All the transactions takes atleast 1 minute to complete.

I assume that the user might be pressing the "STOP" button of the
browser before the transaction gets completed.
Due to this although we take the connection from the pool but not able
to return back as the last lines of the code are
not reached. I think  that if i had written con.close() in the finally
block then this problem would have not come.

Is there any way by which i can specify in the struts config .xml to
close the connection which are not active or not doing anything.

Regards
Shailender Jain