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 |
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 |