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

Поиск
Список
Период
Сортировка
От Steven Schlansker
Тема Re: How to set transaction isolation level for the given transaction only.
Дата
Msg-id CAHjY6CV7B30wTHKMZeiyOc51iAW+TEHn+cTa5ebLutebLuR4QQ@mail.gmail.com
обсуждение исходный текст
Ответ на How to set transaction isolation level for the given transaction only.  (Andy Fan <zhihui.fan1213@gmail.com>)
Ответы Re: How to set transaction isolation level for the given transaction only.
Список pgsql-jdbc
Дерево обсуждения
Maybe there's a neat way of doing this in the driver I'm not aware of, but usually this is left to the job of a higher level library or class you write yourself.

To shamelessly plug my own, Jdbi handles this nicely:
http://jdbi.org/apidocs/org/jdbi/v3/core/Handle.html#inTransaction-org.jdbi.v3.core.transaction.TransactionIsolationLevel-org.jdbi.v3.core.HandleCallback-

On Thu, Aug 13, 2020 at 5:53 AM Andy Fan <zhihui.fan1213@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: Andy Fan
Дата:
Сообщение: How to set transaction isolation level for the given transaction only.
Следующее
От: Andy Fan
Дата:
Сообщение: Re: How to set transaction isolation level for the given transaction only.