Postgres Pro
Downloads
Home   >   mailing lists

Re: How to set transaction isolation level for the given transaction only. - Mailing list pgsql-jdbc

From Steven Schlansker
Subject Re: How to set transaction isolation level for the given transaction only.
Date
Msg-id CAHjY6CV7B30wTHKMZeiyOc51iAW+TEHn+cTa5ebLutebLuR4QQ@mail.gmail.com
Whole thread Raw
In response to How to set transaction isolation level for the given transaction only.  (Andy Fan <zhihui.fan1213@gmail.com>)
Responses Re: How to set transaction isolation level for the given transaction only.  (Andy Fan <zhihui.fan1213@gmail.com>)
List pgsql-jdbc
Tree view
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 by date:

Previous
From: Andy Fan
Date:
Subject: How to set transaction isolation level for the given transaction only.
Next
From: Andy Fan
Date:
Subject: Re: How to set transaction isolation level for the given transaction only.