Skip site navigation (1) Skip section navigation (2)

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

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Oliver Jowett <oliver(at)opencloud(dot)com>
Cc: Russ Tennant <russ(at)i2rd(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: "org.postgresql.util.PSQLException: This ResultSet is
Date: 2005-10-05 23:20:31
Message-ID: 076EFC36-4950-4E7D-9AC6-540B999F5449@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
The more interesting thing is what do HSQL and MySql return here ;)

Dave
On 5-Oct-05, at 6:38 PM, Oliver Jowett 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
>
> ---------------------------(end of  
> broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>


In response to

pgsql-jdbc by date

Next:From: Peter CookDate: 2005-10-06 05:06:06
Subject: Getting connected
Previous:From: Russ TennantDate: 2005-10-05 23:17:50
Subject: Re: "org.postgresql.util.PSQLException: This ResultSet is closed" in call to rst.getString(..)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group