Thread: error note

error note

From
Roger Pack
Date:
Lacking a better place to send this, it turns out that the error message
org.postgresql.util.PSQLException: This ResultSet is closed.
in JSP's may mean that you uses a Statement, return a resultset from that same statement, then (without finishing with the resultset) you re-use the statement (which re-sets the resultset) then try to re-use the resultset (i.e. be careful with using the same statement over and over).
Just a note for those who run into this.
Thanks.
-Roger

--
Love is the only force that can erase the differences between people, that can heal relationships shattered by bitterness.

Re: error note

From
Guillaume Cottenceau
Date:
Roger Pack <roger.byucougar 'at' gmail.com> writes:

> Lacking a better place to send this, it turns out that the error message
> org.postgresql.util.PSQLException: This ResultSet is closed.
> in JSP's may mean that you uses a Statement, return a resultset from that
> same statement, then (without finishing with the resultset) you re-use the
> statement (which re-sets the resultset) then try to re-use the resultset (
> i.e. be careful with using the same statement over and over).
> Just a note for those who run into this.

Per Sun documentation.

"A ResultSet object is automatically closed when the Statement
object that generated it is closed, re-executed, or used to
retrieve the next result from a sequence of multiple results."

http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSet.html

--
Guillaume Cottenceau