Re: "org.postgresql.util.PSQLException: This ResultSet is

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Russ Tennant <russ(at)i2rd(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "org.postgresql.util.PSQLException: This ResultSet is
Date: 2005-10-05 22:38:00
Message-ID: 434455C8.5030203@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Russ Tennant wrote:
> It appears the result set is considered closed even though
> ResultSet.next() returns true in this case.

Uh, you are calling getString on a different ResultSet to the one you
called next() on:

> ResultSet rstVersionColumns=meta.getVersionColumns(null, null, tableName);
>
> while (rstVersionColumns.next())
>
> {
>
> String fieldName=rstColumn.getString("COLUMN_NAME"); // Exception thrown
> here

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Russ Tennant 2005-10-05 23:17:50 Re: "org.postgresql.util.PSQLException: This ResultSet is closed" in call to rst.getString(..)
Previous Message Russ Tennant 2005-10-05 22:18:20 "org.postgresql.util.PSQLException: This ResultSet is closed" in call to rst.getString(..)