Closing ResultSet and Statements - Mailing list pgsql-jdbc

From Antony Paul
Subject Closing ResultSet and Statements
Date
Msg-id BAY15-DAV106PkdlKOz0000ea69@hotmail.com
Whole thread Raw
Responses Re: Closing ResultSet and Statements
List pgsql-jdbc
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



pgsql-jdbc by date:

Previous
From: Shikha Aggarwal
Date:
Subject: how to migrate???
Next
From: Dave Cramer
Date:
Subject: Re: Closing ResultSet and Statements