Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: pros/cons of dedicated vs. MTS connections?
Mark Bole wrote:
> Billy wrote:
>
>> Mark Bole wrote: >> >>> That's the whole point of a JDBC connection pool -- you never close the >>> connection. >> >> You're missing the fact that I was talking about JDBC connection pool >> leaking. I.e. the connection pool continues to grow, with original >> pooled connections not being used (and the socket handle still open). >> This means that the number of sessions on the Oracle side keeps on >> increasing.
Correct, and further, WebLogic has ways of observing and recovering pooled connections that have been idle for a configurable period, whether or not the user-level connection reference had been lost, so all leaks can be repaired automatically within seconds of the maximum normal time the application would properly hold and use a connection. A full stacktrace of the user code that obtained the connection (and then leaked or ignored it) is also logged for help in code repair.
Joe Weinstein at BEA Systems Received on Thu Sep 15 2005 - 19:55:11 CDT