logo       

patch: add a finalizer to AbstractJdbc1Statement: msg#00182

db.postgresql.jdbc

Subject: patch: add a finalizer to AbstractJdbc1Statement

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-statement_finalizer.txt
Description: Text document


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
<Prev in Thread] Current Thread [Next in Thread>
Google Custom Search

News | FAQ | advertise