transaction isolation level

From: "josh hes(dot)" <jbhester(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: transaction isolation level
Date: 2006-08-28 17:49:20
Message-ID: 20060828174920.56041.qmail@web53714.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We recently updated our postgres to 8.1.4, since then
I’ve been getting the following error:

[Aug 28, 2006 5:43:16 AM ERROR]
org.postgresql.util.PSQLException: Cannot change
transaction isolation level in the middle of a
transaction.
at
org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(AbstractJdbc2Connection.java:729)
at com.evermind._in.setTransactionIsolation(Unknown
Source)
at com.evermind._in.setTransactionIsolation(Unknown
Source)
at com.evermind._in.setTransactionIsolation(Unknown
Source)

Here is an example of the code that does this:

Connection con = null;
try
{
DataSource ds = (DataSource)
ctx.lookup("jdbc/EncounterEJBDS");
con = ds.getConnection();

con.setTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);
.
.
.

Anybody experienced this or have a fix?

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bjørn T Johansen 2006-08-28 17:50:42 Can't see what's wrong with this function?
Previous Message Brandon Aiken 2006-08-28 17:28:34 Precision of data types and functions