Another exception (Transaction level)

From: Ole Streicher <ole-usenet-spam(at)gmx(dot)net>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Another exception (Transaction level)
Date: 2003-07-25 12:09:46
Message-ID: qfd6fyx0xh.fsf@ebp00439.ebp.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

sorry if I flood you with lots of messages, but I am quite new to
Postgresql and I find a lot of questions not answered in the manual.

I get randomly (probably when I have concurrent r/w access) the error
message

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

when I do a commit(). But I had set this level at the very beginning with

dbConn.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

BTW, I tried to use TRANSACTION_READ_UNCOMMITTED (which is described
in the manual) but in this case I get "Transaction isolation level 1
is not supported."

What is wrong here? Why do I get an error message when I try to use
the "read uncommitted" level, and why I get the exception when I use
commit() after setting the transaction level to "read committed"?

Ciao

Ole

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Felipe Schnack 2003-07-25 12:18:59 Re: quick question about PreparedStatements
Previous Message Ole Streicher 2003-07-25 11:45:40 Problem with LargeObject/jdbc when writing short (Repost)