transaction isolation level

Поиск
Список
Период
Сортировка
От josh hes.
Тема transaction isolation level
Дата
Msg-id 20060828174920.56041.qmail@web53714.mail.yahoo.com
обсуждение исходный текст
Ответы Re: transaction isolation level  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: "macgillivary"
Дата:
Сообщение: Re: How do i store arbitrary questions and answers in SQL?
Следующее
От: ptjm@interlog.com (Patrick TJ McPhee)
Дата:
Сообщение: Deathly slow performance on SMP red-hat system