Re: Multiple open ResultSets not allowed?

From: Barry Lind <blind(at)xythos(dot)com>
To: Jeff Kolesky <jeff(at)edusoft(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Multiple open ResultSets not allowed?
Date: 2003-03-15 03:55:53
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-jdbc

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.


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
> (
> 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?

In response to


Browse pgsql-jdbc by date

  From Date Subject
Next Message Barry Lind 2003-03-15 04:02:53 Re: idle in transaction
Previous Message Jeff Kolesky 2003-03-15 00:20:26 Multiple open ResultSets not allowed?