|From:||Barry Lind <blind(at)xythos(dot)com>|
|To:||Jeff Kolesky <jeff(at)edusoft(dot)com>|
|Subject:||Re: Multiple open ResultSets not allowed?|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
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 org.postgresql.jdbc1.AbstractJdbc1ResultSet.next
> 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?
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
|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?|