[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Closed ResultSet error
From:       Kris Jurka <books () ejurka ! com>
Date:       2008-04-30 20:06:37
Message-ID: Pine.BSO.4.64.0804301604490.11710 () leary ! csoft ! net
[Download RAW message or body]



On Wed, 30 Apr 2008, Bayless Kirtley wrote:

> I am migrating from another database to PostgreSQL and have run into a 
> serious problem. The Java program runs fine on the other DB but under 
> PostgreSQL it gives the error, "ResultSet is closed."
>
> I have removed all occurrences of closing any result sets and there are 
> no instances of closing underlying statements within those methods. 
> Finally, I have stepped through the entire operation with a debugger and 
> found no unexpected events. Each time a new result set was created, the 
> debugger indicated it to be a new entity. When finally returning to the 
> original, it appeared to be the correct instance.

When the same statement is used to execute a second query, the first 
ResultSet is closed automatically.  I'm guessing that this is what's 
happening to you and you need to be sure to create a new Statement for 
each concurrently open ResultSet you have.

Kris Jurka

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]