Skip site navigation (1) Skip section navigation (2)

Getting "This ResultSet is closed" exceptions

From: "Paul Tomblin" <ptomblin(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Getting "This ResultSet is closed" exceptions
Date: 2008-02-18 14:19:37
Message-ID: 8efd35820802180619l352d9b0eta35788642a5fc4eb@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
I have some code that works most of the time, but I left it running
overnight and at 3am I got the "This ResultSet is closed" exception on
the "while (rs.next())" line in the following code:

            ResultSet rs = getPerformancesOnVenueStmt.executeQuery();

            while(rs.next())
            {
                Performance performance = parseResultSet(null, null, rs);
                if (performance != null)
                  retList.add(performance);
            }
            rs.close();

The method "parseResultSet" does not close the result set, it just
does the various "rs.get..." calls and creates a Performance object.

Is it possible that another thread doing a commit on the same
Connection could cause this?

-- 
For my assured failures and derelictions I ask pardon beforehand of my
betters and my equals in my Calling here assembled, praying that in
the hour of my temptations, weakness and weariness, the memory of this
my Obligation and of the company before whom it was entered into, may
return to me to aid, comfort and restrain.

Responses

pgsql-jdbc by date

Next:From: Andres OlarteDate: 2008-02-18 18:51:52
Subject: Re: Getting "This ResultSet is closed" exceptions
Previous:From: AndrewDate: 2008-02-18 14:02:20
Subject: Re: UUID datatype

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group