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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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