From: | Carlos Correia <carlos(at)m16e(dot)com> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | When to close a Statement |
Date: | 2006-02-15 13:03:16 |
Message-ID: | 43F32694.1050005@m16e.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)m16e(dot)com - URL: http://www.m16e.com
AIM: m16e - ICQ: 257488263 - Jabber: m16e(at)amessage(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Schaber | 2006-02-15 13:23:20 | Re: When to close a Statement |
Previous Message | Radek Jíra | 2006-02-14 14:26:23 | An I/O error occured while sending to the backend |