patch: add a finalizer to AbstractJdbc1Statement

From: "Richard DeGrande" <RDegrand(at)co(dot)jefferson(dot)co(dot)us>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: patch: add a finalizer to AbstractJdbc1Statement
Date: 2003-08-20 22:16:16
Message-ID: sf439eca.064@gc6.jefferson.co.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
pgsql-statement_finalizer.txt text/plain 915 bytes
TEXT.txt text/plain 147 bytes

Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-08-21 01:31:51 Re: CVS JDBC driver will try to use server-side-prepare on
Previous Message rajesh kumar 2003-08-20 17:17:01 reg:"Driver Not found-error"- need u r suggestions