Postgres Pro
Downloads
Home   >   mailing lists

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

From David Wall
Subject Re: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
Date
Msg-id 002d01c0cabf$d1b46a40$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-general
Tree view 
> ERROR:  SET TRANSACTION ISOLATION LEVEL must be called before any query
> NOTICE:  current transaction is aborted, queries ignored until end of
transaction block

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.

David

pgsql-general by date:

Previous
From: "David Wall"
Date:
Subject: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
Next
From: Martín Marqués
Date:
Subject: problemas with pgaccess, tcl, libX11.so