Postgres Pro
Downloads
Home   >   mailing lists

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

From Rob Bygrave
Subject Re: How to set transaction isolation level for the given transaction only.
Date
Msg-id CAC=ts-FreXkEdVyuFhW4xNqzCcZ8jpUzK7bnBnANvmuTsGMYbA@mail.gmail.com
Whole thread Raw
In response to Re: How to set transaction isolation level for the given transaction only.  (Andy Fan <zhihui.fan1213@gmail.com>)
List pgsql-jdbc
Tree view
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 by date:

Previous
From: Andy Fan
Date:
Subject: Re: How to set transaction isolation level for the given transaction only.
Next
From: Vladimir Sitnikov
Date:
Subject: [pgjdbc/pgjdbc]