Closed ResultSet error

From: "Bayless Kirtley" <bkirt(at)cox(dot)net>
To: "List, Postgres" <pgsql-general(at)postgresql(dot)org>
Subject: Closed ResultSet error
Date: 2008-04-30 19:56:49
Message-ID: 002d01c8aafd$1fa56540$6401a8c0@Desktop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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."

This result set is created in a method that processes each row sequentially. Within the processing, it passes the result set to another method that retrieves columns from it and creates additional result sets to retrieve related information. This second method can also call itself recursively. This works fine with HSQLDB but fails when returning back to the original method and attempting another loop on the original result set, claiming it 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.

Is there a known problem along these lines? Any help or suggestions will be most appreciated.

Thanks,
Bayless

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kris Jurka 2008-04-30 20:06:37 Re: Closed ResultSet error
Previous Message Scott Marlowe 2008-04-30 19:28:36 Re: question/problem concerning GRANT/REVOKE