Re: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query - Mailing list pgsql-interfaces

From David Wall
Subject Re: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
Date
Msg-id 003501c0cac0$00217c60$5a2b7ad8@expertrade.com
Whole thread Raw
In response to ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query  ("David Wall" <d.wall@computer.org>)
List pgsql-interfaces
> Message:   ERROR:  SET TRANSACTION ISOLATION LEVEL must be called before
any query

Oops.  Sorry.  It looks like it was a bug in the connection pool class that
I've been magically using for a couple of years now.  Apparently the usage
just never ran into the problem, or there's a difference in the Tomcat
servlet engine I'm using that was driving the database.  The code was
reusing the connection for all pool calls from the same thread, and this
somehow created the conflict, probably because of the threadpools used in
Tomcat.

David



pgsql-interfaces by date:

Previous
From: "David Wall"
Date:
Subject: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
Next
From: Lonnie Cumberland
Date:
Subject: removing extraneous objects?