Re: Multiple open ResultSets not allowed?

It definitely was.  Applications I had which worked with nested result
sets using the pre-7.3 driver needed to be cleaned up to be
spec-compliant once the driver was made so.

Tim Lucia


-----Original Message-----
From: Barry Lind [mailto:blind@xythos.com]
Sent: Friday, March 14, 2003 10:56 PM
To: Jeff Kolesky
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] Multiple open ResultSets not allowed?

The error message says that the Connection is closed.  You can't use a
statement or result set after the connection that owns them is closed.
This is part of the jdbc spec, and I think logic in the driver was
tightened up in this area in 7.3.

thanks,
--Barry


Jeff Kolesky wrote:
> I have just switched to using the 7.3 JDBC driver and am no longer
> allowed to have multiple ResultSets open at the same time.
>
> When running code that iterates through two open ResultSets (from two
> different Statements from the same Connection), the following
exception
> is thrown:
>
>     Connection is closed. Operation is not permitted.
>         at org.postgresql.jdbc1.AbstractJdbc1ResultSet.next
> (AbstractJdbc1ResultSet.java:92)
>
> I haven't looked at the AbstractJdbc1ResultSet code to see what is
going
> on, but according to the JDBC Javadocs, "if the reading of one
ResultSet
> object is interleaved with the reading of another, each must have been

> generated by different Statement objects."  Therefore, the code I am
> executing should not throw this exception, and with the previous
version
> of the driver it did not.
>
> Is this a known bug?  Has it been fixed?  Did I misinterpret the
Javadocs?
>
> Thanks.
>
> Jeff
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>




---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)