Skip site navigation (1) Skip section navigation (2)

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

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Altaf Malik <mmalik_altaf(at)yahoo(dot)com>
Cc: James Im <im-james(at)hotmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: how to continue using a connection after an error withautocommit=false
Date: 2007-02-20 15:39:41
Message-ID: 1171985981.25338.44.camel@state.g2switchworks.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Tue, 2007-02-20 at 04:53, Altaf Malik wrote:
> You can either commit or rollback the transaction when you encounter
> an SQL error. This will alow the next statements to execute
> successfully. 

You can't commit after an error in PostgreSQL unless you've rolled back
to a savepoint from before the error.

In response to

pgsql-jdbc by date

Next:From: Hover DongDate: 2007-02-21 03:29:10
Subject: I have questions
Previous:From: Oliver JowettDate: 2007-02-20 11:50:14
Subject: Re: invalid byte sequence for encoding "UTF8": 0x00

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group