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