db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: Why close ResultSet & PreparedStatement?
Date Sat, 29 Nov 2008 22:59:09 GMT
derby@segel.com wrote:
> Ok...
> With respect to *other* databases, you have timeouts which will drop the
> database side of a result set or connection so the resources are recovered.
> Commercial databases will clean things up. (Although its always better to
> clean up your own mess) If you close the database connection, you'll trigger
> the clean up process.
You are over optimistic. It is depressingly common for applications to 
fail if ResultSet's aren't closed aggressively. While Oracle is the 
usual whipping boy for this behaviour, it is by no means unique.

Mark Thornton

View raw message