Thread: Changing transaction isolation mid-transaction

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
>