error note

From: Roger Pack <roger(dot)byucougar(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: error note
Date: 2006-01-19 22:00:15
Message-ID: 966599840601191400p363addcn826b5bebb48c55d1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2006-01-19 22:06:05 Re: ERROR: The backend has broken the connection -- AND: FATAL:
Previous Message Antonio Rodriguez Anaya 2006-01-19 14:46:33 ERROR: The backend has broken the connection -- AND: FATAL: Socket command type unknown