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

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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               
http://archives.postgresql.org