error note - Mailing list pgsql-jdbc

From Roger Pack
Subject error note
Date
Msg-id 966599840601191400p363addcn826b5bebb48c55d1@mail.gmail.com
Whole thread Raw
Responses Re: error note
List pgsql-jdbc
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.

pgsql-jdbc by date:

Previous
From: Prasanth
Date:
Subject: Re: getDate after call to updateDate
Next
From: Will Szopko
Date:
Subject: Inserting an Interval Using JDBC