Re: connection timeouts

["Fred Kulack" <kulack@xxxxxxxxxx>]

On 02/12/2001 at 03:28:24 PM, owner-java400-l@midrange.com wrote:
>Does the AS/400 do anything to close "idle" connections, or should I
>(for example) subclass Connection to add a "last-used" field, updating
>it every time the Connection gets used and then checking on another
>thread to try and reap "idle" connections?  An idle connection would be
>one that hasn't been used for the same length of time as a session
>timeout (30 minutes).

In general for JDBC no.
There are some things unrelated to Java that can be done, but
for this list, I'm sure they are uninteresting. 8-)
I'd do the last used thing with a daemon thread to intermittently
process idle connections.

I might try and fix the code before doing something like
this. Asynchronous closing of connections opens up all
sorts of freaky things.

The native driver has some good support for not letting you
leak connections or statements.
If you have leaks and you're running in JDK 1.2 or later, an
explicit call to the garbage collector once in a while could
probably cause us to cleanup the connections and statements
for you.

BUT...
1) The garbage collector can get pretty expensive sometimes.
2) If your code is actually keeping references to the object
around, calling the garbage collector won't help.

Technical: The use of JDK 1.2 weak references internally
ensures any references to these objects that stop their
garbage collection to be only held by the application, not
by the driver itself.

Do what you see fit.

"Do you believe that my being stronger or faster has anything
 to do with my muscles in this place?" ... "Free your mind."
Laurence Fishburne as Morpheus in 'The Matrix'.

Fred A. Kulack  -  AS/400e  Java and Java DB2 access, Jdbc, JTA, etc...
IBM in Rochester, MN  (Phone: 507.253.5982   T/L 553-5982)
mailto:kulack@us.ibm.com   Personal: mailto:kulack@bresnanlink.net
AOL Instant Messenger: Home:FKulack  Work:FKulackWrk

+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---