ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query

From: "David Wall" <d(dot)wall(at)computer(dot)org>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
Date: 2001-04-21 23:15:46
Message-ID: 000e01c0cab8$fec39e40$5a2b7ad8@expertrade.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

I am getting this error reported back from JDBC. I'm not sure if this is
from JDBC, or from the Postgresql 7.1.

Message: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any
query
SQLState: null
ErrorCode: 0

It seems to occur if run two simultaneous "mass delete" operations. It
appears as though the database connection goes away, since my code then
attempts to reconnect and I get repeated sql exceptions:

Message: No results were returned by the query.
SQLState: null
ErrorCode: 0

I have to restart the programs to get them oprational again.

Thanks,
David

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message David Wall 2001-04-22 00:05:55 Re: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
Previous Message David Wall 2001-04-21 03:11:03 Java timestamps