Re: closing statements when connection is closed

Dave Cramer wrote:
> It would appear from the documentation that we are supposed to clean up
> JDBC resources when Connecton.close is called, would this include
> statements. We currently don't track them or clean them up?
>
> Opinions ?

We'd need JDK 1.2 to do this properly (weak reference support) otherwise
we end up keeping Statements that have not been closed alive as long as
the Connection object is.

As far as I can see the only additional thing we'd be able to clean up
is clearing the reference to row data held by open ResultSet objects.
This is only going to have an effect if something outside the driver is
holding references to the ResultSet or Statement after closing the
connection -- which seems like an application bug to me.

-O