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

Поиск
Список
Период
Сортировка
От Rob Bygrave
Тема Re: How to set transaction isolation level for the given transaction only.
Дата
Msg-id CAC=ts-FreXkEdVyuFhW4xNqzCcZ8jpUzK7bnBnANvmuTsGMYbA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to set transaction isolation level for the given transaction only.  (Andy Fan <zhihui.fan1213@gmail.com>)
Список pgsql-jdbc
Дерево обсуждения
You can set the transaction isolation level on the connection using the setTransactionIsolation method.

java.sql.Connection#setTransactionIsolation()

I believe that is what you are looking for.


Cheers, Rob.

On Fri, 14 Aug 2020 at 17:16, Andy Fan <zhihui.fan1213@gmail.com> wrote:


On Thu, Aug 13, 2020 at 11:16 PM Steven Schlansker <stevenschlansker@gmail.com> wrote:
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-


Thanks for the info,  I will try the similar on my own. 


--
Best Regards
Andy Fan

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

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