Re: SET TRANSACTION ISOLATION LEVEL

Philip,

It would be useful to see the rest of your code. It is hard to determine
what is going on.

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Philip Crotwell
Sent: Friday, February 22, 2002 2:54 PM
To: pgsql-jdbc@postgresql.org
Subject: [JDBC] SET TRANSACTION ISOLATION LEVEL



Hi

I got this error, it isn't the first transaction since the server was
started, so I don't understant what it means. The docs seem to suggest
that the READ COMMITTED level is default. If there is a default, why do
I need to set it?

I am AFAIK running single threaded in my java code, so I don't think I
would be dong two separate transactions in the same connection.

postgres 7.1. and this code involved is to get large objects, so it is
non-auto-commiting.

thanks,
PHilip


 java.sql.SQLException: ERROR:  SET TRANSACTION ISOLATION LEVEL must be
called be fore any query

        at org.postgresql.Connection.ExecSQL(Connection.java:533)
        at org.postgresql.Connection.ExecSQL(Connection.java:400)
        at
org.postgresql.jdbc2.Connection.doIsolationLevel(Connection.java:412)
        at org.postgresql.jdbc2.Connection.commit(Connection.java:226)
    ...

And from the server log:

NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'quit_pkey'
for tab le 'quit'
ERROR:  Relation 'quit' already exists
ERROR:  Relation 'plottable_cache_seq' already exists
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'quit_pkey'
for tab le 'quit'
ERROR:  Relation 'quit' already exists
DEBUG:  MoveOfflineLogs: remove 0000000C000000E4
pq_flush: send() failed: Broken pipe
pq_recvbuf: unexpected EOF on client connection
DEBUG:  MoveOfflineLogs: remove 0000000C000000E5
ERROR:  Relation 'event' does not exist
DEBUG:  MoveOfflineLogs: remove 0000000C000000E6
NOTICE:  BEGIN: already a transaction in progress
ERROR:  SET TRANSACTION ISOLATION LEVEL must be called before any query
NOTICE:  current transaction is aborted, queries ignored until end of
transactio n block
NOTICE:  current transaction is aborted, queries ignored until end of
transactio n block
NOTICE:  current transaction is aborted, queries ignored until end of
transactio n block
NOTICE:  current transaction is aborted, queries ignored until end of
transactio n block
NOTICE:  current transaction is aborted, queries ignored until end of
transactio n block
NOTICE:  current transaction is aborted, queries ignored until end of
transactio n block




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

http://archives.postgresql.org