Re: "org.postgresql.util.PSQLException: This ResultSet is closed" in call to rst.getString(..)

On Wednesday 05 October 2005 5:38 pm, you wrote:
> 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

Ahah! :) Sorry for the false alarm.

--
Russ Tennant
russ(at)i2rd(dot)com