When to close a Statement - Mailing list pgsql-jdbc

From Carlos Correia
Subject When to close a Statement
Date
Msg-id 43F32694.1050005@m16e.com
Whole thread Raw
Responses Re: When to close a Statement  (Achilleus Mantzios <achill@matrix.gatewaynet.com>)
Re: When to close a Statement  (Markus Schaber <schabi@logix-tt.com>)
List pgsql-jdbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

After having had some problems with JDBC statements, as I mentioned in a
previous post, due to different behaviours between versions 7.x and 8.x
in the way Postgres deals with statements, I would like to know what is
the proper way of dealing with this.

I realized that the need to close the statement is implementaion
dependent, and now I'm a bit confused as I can't find anything in
Postgres docs about this issue... so the questions are:

- - must I close the statement after *every* executeXXX method call?

- - should I also close the connection as well, or may I leave it open
during the application execution?

Thanks,

Carlos
- --
MEMÓRIA PERSISTENTE, Lda.
Tel.: 219 291 591 - GSM:  967 511 762
e-mail: geral@m16e.com - URL: http://www.m16e.com
AIM: m16e - ICQ: 257488263 - Jabber: m16e@amessage.de
Skype.com username (VoIP): m16e.com
GnuPG: wwwkeys.eu.pgp.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFD8yaU90uzwjA1SJURAsyhAJ9twvK/oeZXrq/SEyoR9TaGr3ZNdQCgwaBC
H3eHaRZdHmZ3FuIhs/xgDIs=
=UI89
-----END PGP SIGNATURE-----

pgsql-jdbc by date:

Previous
From: Radek Jíra
Date:
Subject: An I/O error occured while sending to the backend
Next
From: Achilleus Mantzios
Date:
Subject: Re: When to close a Statement