How to set transaction isolation level for the given transaction only.

Поиск
Список
Период
Сортировка
От Andy Fan
Тема How to set transaction isolation level for the given transaction only.
Дата
Msg-id CAKU4AWpH7K1Fu52e8SWiiFHUkB252_WiYecZGm7y6GWcTXytCg@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to set transaction isolation level for the given transaction only.  (Steven Schlansker <stevenschlansker@gmail.com>)
Список pgsql-jdbc
In database server, it has a default isolation level,  and if we want to use
a different one, we can easily do:

begin;
set transaction isolation level xx; 

commit; 

We can see that the isolation level is set at the transaction level.  However when I
check the API,  looks I can only set it at *connection* level via Connection.setTransactionIsolation(x);  If I want to rollback the original, I have
to remember to reset it after this transaction which would be boring in practice. 
What would be the best practice for this? 

--
Best Regards
Andy Fan

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

Предыдущее
От: Sehrope Sarkuni
Дата:
Сообщение: [pgjdbc/pgjdbc] 0aa6d2: fix: Remove unused .ratignore (#1857)
Следующее
От: Steven Schlansker
Дата:
Сообщение: Re: How to set transaction isolation level for the given transaction only.