Re: how to continue using a connection after an error with autocommit=false

From: Tim Pizey <timp(at)melati(dot)org>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: how to continue using a connection after an error with autocommit=false
Date: 2007-02-28 20:41:12
Message-ID: 200702282041.13013.timp@melati.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Tuesday 20 February 2007 10:50, Heikki Linnakangas wrote:
> James Im wrote:
> > I just find out that I cannot continue using a connection when I use
> > autocommit=false and that an sql insert failed.
>
> That's intended behavior in PostgreSQL.
[snip]
This is new behaviour in version 8, I believe.

I think this behaviour is unique to Postgresql?

Melati was developed with Postgresql version 6 as the target dbms
back in 2000, since then it has been extended to work with the other common
dbmsen, but now it looks like it won't work with V8, without quite a bit of
rework.

Is this behaviour specified by a standard?

What are the advantages?

yours
Tim Pizey

--
http://melati.org/ - the flower of Java.

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Dave Cramer 2007-02-28 22:33:40 Re: how to continue using a connection after an error with autocommit=false
Previous Message Kris Jurka 2007-02-28 07:44:25 Re: getProcedureColumns