| Lists: | pgsql-jdbc |
|---|
| From: | "John Laban" <johnl(at)infotn(dot)com> |
|---|---|
| To: | <pgsql-jdbc(at)postgresql(dot)org> |
| Subject: | Changing transaction isolation mid-transaction |
| Date: | 2003-04-02 14:49:27 |
| Message-ID: | 017d01c2f927$0f636c50$5ac8a8c0@infotn9 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-jdbc |
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 transaction or 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
| From: | Barry Lind <blind(at)xythos(dot)com> |
|---|---|
| To: | John Laban <johnl(at)infotn(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: Changing transaction isolation mid-transaction |
| Date: | 2003-04-02 16:39:30 |
| Message-ID: | 3E8B1242.7000706@xythos.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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 transaction or 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
>