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

From Jan de Visser
Subject Re: Getting "This ResultSet is closed" exceptions
Date
Msg-id 200802182017.58477.jdevisser@digitalfairway.com
Whole thread Raw
In response to Re: Getting "This ResultSet is closed" exceptions  ("Paul Tomblin" <ptomblin@gmail.com>)
Responses Re: Getting "This ResultSet is closed" exceptions  (Paul Tomblin <ptomblin@gmail.com>)
List pgsql-jdbc
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.

You are applying liberal amounts of lipstick on an animal that to everybody
looks conspicuously like a porcine. Do yourself a favour. Introduce a
connection pool before you (or worse, your customers) go insane.

jan

--
--------------------------------------------------------------
Jan de Visser                     jdevisser@digitalfairway.com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------

pgsql-jdbc by date:

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