Re: Getting "This ResultSet is closed" exceptions

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(at)xcski(dot)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