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 [email protected]
Whole thread Raw
In response to Re: Getting "This ResultSet is closed" exceptions  (Jan de Visser <[email protected]>)
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 <[email protected]> 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()