[GENERAL] transaction isolation level

[josh hes.]

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 

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend