Postgres Pro
Downloads
Home   >   mailing lists

transaction isolation level - Mailing list pgsql-general

From josh hes.
Subject transaction isolation level
Date
Msg-id 20060828174920.56041.qmail@web53714.mail.yahoo.com
Whole thread Raw
Responses Re: transaction isolation level  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "macgillivary"
Date:
Subject: Re: How do i store arbitrary questions and answers in SQL?
Next
From: ptjm@interlog.com (Patrick TJ McPhee)
Date:
Subject: Deathly slow performance on SMP red-hat system