Re: how to continue using a connection after an error with autocommit=false - Mailing list pgsql-jdbc

From Tim Pizey
Subject Re: how to continue using a connection after an error with autocommit=false
Date
Msg-id 200702282041.13013.timp@melati.org
Whole thread Raw
In response to Re: how to continue using a connection after an error with autocommit=false  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: how to continue using a connection after an error with autocommit=false
List 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.

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: getProcedureColumns
Next
From: Dave Cramer
Date:
Subject: Re: how to continue using a connection after an error with autocommit=false