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
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) |