| 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: | Whole Thread | Raw Message | 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 |