patch: add a finalizer to AbstractJdbc1Statement - Mailing list pgsql-jdbc

From Richard DeGrande
Subject patch: add a finalizer to AbstractJdbc1Statement
Date
Msg-id sf439eca.064@gc6.jefferson.co.us
Whole thread Raw
List pgsql-jdbc
This patch adds a finalizer to AbstractJdbc1Statement that closes the
statement. Without this, when server-side preparation is in use
statements
that are executed then discarded without an explicit close() will leak
resources on the backend while that connection remains open, as a
DEALLOCATE
never gets executed.

Objects with a finalizer are more expensive to create (depending on the
VM).
If it's too much of a price to pay in the general case, there's
another
approach that uses phantom references and only pays the cost when
backend
resources are actually allocated, but the code becomes much more
complex.

-O

Attachment

pgsql-jdbc by date:

Previous
From: "Waldomiro"
Date:
Subject: FETCH and MOVE
Next
From: Dave Cramer
Date:
Subject: Re: FETCH and MOVE