Hosting Provided By

Re: [JDBC] Getting "This ResultSet is closed" exceptions

From: Paul Tomblin <ptomblin(at)gmail.com>
Date: Mon Feb 18 2008 - 20:23:45 EST

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.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

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               
http://www.postgresql.org/docs/faq

Received on Mon Feb 18 20:26:37 2008

This message: [ Message body ]
Next message: Oliver Jowett: "Re: [JDBC] Implementing setQueryTimeout()"
Previous message: Tom Lane: "Re: [JDBC] Implementing setQueryTimeout()"
In reply to: Jan de Visser: "Re: [JDBC] Getting "This ResultSet is closed" exceptions"
Next in thread: Dave Cramer: "Re: [JDBC] Getting "This ResultSet is closed" exceptions"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Wed Jun 18 2008 - 23:44:48 EDT