Re: Changing transaction isolation mid-transaction - Mailing list pgsql-jdbc

From Barry Lind
Subject Re: Changing transaction isolation mid-transaction
Date
Msg-id 3E8B1242.7000706@xythos.com
Whole thread Raw
In response to Changing transaction isolation mid-transaction  ("John Laban" <johnl@infotn.com>)
List pgsql-jdbc
John,

 From what I remember when looking at this last you are correct.  The
change takes effect when the next transaction starts.

--Barry

John Laban wrote:
> Quick question...
>
> In Sun's API for the Connection class, in the setTransactionIsolation(int) method, there is a note that says:
>
> Note: If this method is called during a transaction, the result is implementation-defined.
>
> What happens with the postgresql jdbc driver?  Does the transaction isolation actually change during the current
transactionor does it wait until the next transaction? 
>
> From my preliminary testing it seems to be the latter, but I was wondering if anybody knew for sure.
>
>
> Thanks,
> John Laban
>


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: prepared statements and sequences
Next
From: Ryan Christianson
Date:
Subject: Jdbc3PoolingDataSource default auto commit is false