Re: Getting "This ResultSet is closed" exceptions - Mailing list pgsql-jdbc

From Paul Tomblin
Subject Re: Getting "This ResultSet is closed" exceptions
Date
Msg-id 47BA2FA1.2040703@gmail.com
Whole thread Raw
In response to Re: Getting "This ResultSet is closed" exceptions  (Jan de Visser <jdevisser@digitalfairway.com>)
List pgsql-jdbc
Jan de Visser wrote:
> On Monday 18 February 2008 18:07:59 Paul Tomblin wrote:
>>  I've turned off autocommit, and am
>> running around the code trying to figure out where is the best place
>> to put "conn.commit();" calls.
>
> Come again? You are using a single connection and are calling commit and
> seemingly random spots? That means that thread A will call commit while
> thread B is in the middle of doing things.

Like I said, it's been running in autocommit mode for about 6 years now.  Any
problems that might have occurred from an inconsistent database have been seen
and rectified long ago.


--
Paul Tomblin <ptomblin@xcski.com> http://blog.xcski.com/
Sept 25th:  Discovered lots of things about Dynamic HTML.
             Notably that almost every site attempting to use it is crap.
               -- Alan Cox's diary

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: Implementing setQueryTimeout()
Next
From: Oliver Jowett
Date:
Subject: Re: Implementing setQueryTimeout()