Re: Connection Properties for FetchSize and Autocommit - Mailing list pgsql-jdbc

From David Langton
Subject Re: Connection Properties for FetchSize and Autocommit
Date
Msg-id 7c49e7040910120935p16a9bd25p5dea5098a04a6e5f@mail.gmail.com
Whole thread Raw
In response to Connection Properties for FetchSize and Autocommit  (David Langton <djlangton+pgjdbc@googlemail.com>)
List 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!

pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Re: Connection Properties for FetchSize and Autocommit
Next
From: "Carsten Klein (tarent)"
Date:
Subject: Re: TimeZone related issues in org.postgresql.jdbc2.TimestampUtils