tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Shapira, Yoav" <>
Subject [OFF-TOPIC] RE: Is it ok to close connection in finalize() ?
Date Fri, 21 Feb 2003 14:24:36 GMT


>This is a bit off topic.

Then please mark it as such.  See modified Subject for this message.

>I am using connection pooling, and in my code, I open all the
connection I
>need in an object constructor.
>Then I will close this connection in finalize(), which (according to
what I
>read) will be executed during java garbage collect.

Bad practice.  Connections are scarce resources and should be held for
the minimum amount of time.  Grab them from the pool, run whatever query
you need, release them back to the pool.  Make sure your release code
handles exception and does not hold on to connections.

Do not wait for the finalize() methods.  They will be called during GC,
yes, but it is difficult if not impossible to know exactly when GC will
be called for your specific objects, even after no references are held
to them.

Yoav Shapira
Millennium ChemInformatics

This e-mail, including any attachments, is a confidential business communication, and may
contain information that is confidential, proprietary and/or privileged.  This e-mail is intended
only for the individual(s) to whom it is addressed, and may not be saved, copied, printed,
disclosed or used by anyone else.  If you are not the(an) intended recipient, please immediately
delete this e-mail from your computer system and notify the sender.  Thank you.

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message