I do not see any SQL Exceptions thrown by my query. And I do not see any reason why it should happen on every 44th or 45th time. Not always.!!
I moved to jdbc24pool and it works fine.
You are right, some one should look at this and try to fix it.
Thanks, Anil
Jenny Brown wrote:
On Thu, 3 Jul 2003, adkumar wrote:
Hi all,
I am testing Torques' old connection pool.
To test the connection I am running a query every minute. After every 45/46 minute, it looks like
a new connection is made and even after connection time out, it is not released.
I would just like to add that I have also seen connection leaks during exception handling. If an error occurs (SQL exception from a missing column or something), then Torque seems to leak that connection and not clean up after itself. This happens no matter whether I create the connection and pass it to Torque, or whether I let Torque make its own connections.
I don't have many details or confirmations but I have seen the behavior very regularly. So, if someone is checking into pooling and connection cleanup, it may be useful to look into this too.
Jenny Brown
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
