pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
2+ messages / 1 participants
[nested] [flat]
* ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
@ 2001-04-21 23:15 David Wall <d.wall@computer.org>
0 siblings, 1 reply; 2+ messages in thread
From: David Wall @ 2001-04-21 23:15 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query
@ 2001-04-22 00:05 David Wall <d.wall@computer.org>
parent: David Wall <d.wall@computer.org>
0 siblings, 0 replies; 2+ messages in thread
From: David Wall @ 2001-04-22 00:05 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-04-22 00:05 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-04-21 23:15 ERROR: SET TRANSACTION ISOLATION LEVEL must be called before any query David Wall <d.wall@computer.org>
2001-04-22 00:05 ` David Wall <d.wall@computer.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox