Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Closing ResultSet and Statements


  • From: "Antony Paul" <antonypaul24(at)hotmail(dot)com>
  • To: "pgsql-jdbc" <pgsql-hdbc(at)postgresql(dot)org>
  • Subject: Closing ResultSet and Statements
  • Date: Mon, 23 Aug 2004 13:54:36 +0530
  • Message-id: <BAY15-DAV106PkdlKOz0000ea69@hotmail.com> <text/plain>

Hi all,
(Sorry if repost. I posted it some days ago but couldn't  found on the list)
1. Is it necessary to close all ResultSet and Statements in PostgreSQL.
2. How to know that a ResultSet is open ?. Any views to query this
information?.
3. Do closing a Statement closes the ResultSet ?.
4. I saw an option of  autocommit = true in the postgresql.conf file. What
is its use. What is the default behaviour if it is commented. If I set this
to true do I have commit on all connections obtained without using a
connection pool ?.

rgds
Antony Paul




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group