Re: how to continue using a connection after an error with autocommit=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 with autocommit=false
Date: 2007-02-20 15:39:41
Message-ID: 1171985981.25338.44.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

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