Skip site navigation (1) Skip section navigation (2)

Re: revisiting transaction isolation

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Kris Jurka <books(at)ejurka(dot)com>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: revisiting transaction isolation
Date: 2004-07-20 09:04:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-jdbc
Oliver Jowett wrote:

> A quick skim of AbstractJdbc2Connection turns up these methods as 
> candidates for ignoring autocommit:
>  - getTransactionIsolation()
>  - getPGType (both versions) on a cache miss
> It seems reasonable to suppress BEGINs for both of those cases. I can 
> put together a patch to do that. I'll leave the metadata queries alone 
> for the moment.

And here is the patch.

I reworked execSQLQuery / execSQLUpdate to always ignore autocommit, 
since all places they're called from want this behaviour. Also tweaked 
them to detect unexpected cases (no resultset from query, resultset from 


Attachment: pgjdbc-isolation-ignores-autocommit.txt
Description: text/plain (12.9 KB)

In response to


pgsql-jdbc by date

Next:From: Oliver JowettDate: 2004-07-20 21:38:58
Previous:From: Oliver JowettDate: 2004-07-20 06:24:41
Subject: Re: patch: ensure testdbencoding test table is dropped

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group