Re: autocommit trouble with jdbc on Postgres 7.4

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: Bob Cart <bob(at)cartdev(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: autocommit trouble with jdbc on Postgres 7.4
Date: 2003-12-02 07:31:54
Message-ID: 20031202073154.GJ19205@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tue, Dec 02, 2003 at 07:05:32AM +0100, pginfo wrote:
>
>
> Oliver Jowett wrote:
>
> > On Sun, Nov 30, 2003 at 06:53:24PM -0800, Bob Cart wrote:
> >
> > [...]
> >
> > > Some brave soul out there needs to dig into that part of the driver
> > > code to see what's up. Go for it Oliver!
> >
> > Ok. After some digging, the postgresql driver shipped with the app is fairly
> > old (at least 6 months) and includes code that makes server-side autocommit
> > reflect jdbc-side autocommit. This doesn't work on a 7.4 server.
> >
> > Using the 7.4 stable CVS driver everything appears to behave correctly.
> >
>
> Exist any compiled version for this driver ready for download?It is realy
> problem.
> We also have many systems running old code.

The 7.4 "development" drivers at http://jdbc.postgresql.org/ appear to be
recent enough (although the 7.3 "stable" drivers aren't), or you can build
from the code in the 7.4.0 release (./configure --with-java) if you want to
build them yourself but not from CVS.

-O

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2003-12-02 08:18:49 patch: add get/setPrepareThreshold to PGStatement, PGConnection, datasources
Previous Message Oliver Jowett 2003-12-02 06:42:15 Server-prepared statements fail to handle some rollback cases