Re: closing statements when connection is closed - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: closing statements when connection is closed
Date
Msg-id 1076415914.16154.151.camel@localhost.localdomain
Whole thread Raw
In response to Re: closing statements when connection is closed  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: closing statements when connection is closed
List pgsql-jdbc
I don't see an issue in requiring jdk 1.2, we discussed deprecation of
1.1 support anyway.

I didn't envision using the weak references mechanism, but that seems
like a good solution.

In the JDBC API Tutorial and Reference, it suggests that driver
implementors assume the worst, so I think that we should attempt to
clean up our clients connections as best we can.

Dave
On Mon, 2004-02-09 at 23:33, Oliver Jowett wrote:
> 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
>
--
Dave Cramer
519 939 0336
ICQ # 14675561


pgsql-jdbc by date:

Previous
From: "Iain"
Date:
Subject: Re: closing statements when connection is closed
Next
From: Dave Cramer
Date:
Subject: Re: Pl/Java 1.0.0.b now avaiable on Linux 386 and Cygwin