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

Re: Connection Properties for FetchSize and Autocommit

From: David Langton <djlangton+pgjdbc(at)googlemail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Connection Properties for FetchSize and Autocommit
Date: 2009-10-12 16:35:21
Message-ID: 7c49e7040910120935p16a9bd25p5dea5098a04a6e5f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
>
> The issue I see is that it can cause silent data loss. An application that
> expects the documented API default - autocommit on - and just does some
> UPDATEs is going to throw away all its changes if autocommit is mysteriously
> off by default, because it's never going to call commit().
>
> -O
>

Yes, of course you are right and it would be very bad indeed.  I guess
I wasn't thinking of the impact properly (the app I am working with
isn't doing updates).

Maybe I'll revisit this again one day, but think about it a bit more first!

In response to

pgsql-jdbc by date

Next:From: Carsten Klein (tarent)Date: 2009-10-15 18:01:06
Subject: Re: TimeZone related issues in org.postgresql.jdbc2.TimestampUtils
Previous:From: Oliver JowettDate: 2009-10-11 22:16:56
Subject: Re: Connection Properties for FetchSize and Autocommit

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