Обсуждение: Changing transaction isolation mid-transaction

Поиск
Список
Период
Сортировка

Changing transaction isolation mid-transaction

От
"John Laban"
Дата:
Quick question...
 
In Sun's API for the Connection class, in the setTransactionIsolation(int) method, there is a note that says:
 
Note: If this method is called during a transaction, the result is implementation-defined.
 
What happens with the postgresql jdbc driver?  Does the transaction isolation actually change during the current transaction or does it wait until the next transaction?
 
From my preliminary testing it seems to be the latter, but I was wondering if anybody knew for sure.
 
 
Thanks,
John Laban

Re: Changing transaction isolation mid-transaction

От
Barry Lind
Дата:
John,

 From what I remember when looking at this last you are correct.  The
change takes effect when the next transaction starts.

--Barry

John Laban wrote:
> Quick question...
>
> In Sun's API for the Connection class, in the setTransactionIsolation(int) method, there is a note that says:
>
> Note: If this method is called during a transaction, the result is implementation-defined.
>
> What happens with the postgresql jdbc driver?  Does the transaction isolation actually change during the current
transactionor does it wait until the next transaction? 
>
> From my preliminary testing it seems to be the latter, but I was wondering if anybody knew for sure.
>
>
> Thanks,
> John Laban
>