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

Re: 25P02 on connection.rollback(savePoint) - ERROR: current transaction is aborted, commands ignored until end of transaction block

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Saravana Kumar *EXTERN*" <tskumar2000(at)yahoo(dot)com>,<pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: 25P02 on connection.rollback(savePoint) - ERROR: current transaction is aborted, commands ignored until end of transaction block
Date: 2009-06-02 11:00:51
Message-ID: D960CB61B694CF459DCFB4B0128514C202FF6614@exadv11.host.magwien.gv.at (view raw or flat)
Thread:
Lists: pgsql-jdbc
Saravana Kumar wrote:
> We are currently using Oracle at this time and we are 
> extending postgres support for our application.  In few parts 
> of application, when an unique constraint violation occurs, 
> we ignore and move on (per design) and in that scenario, I am 
> running into 25P02 error on statement subsequent to unique 
> constraint violation. 
>  
> I read the postgres archives and as suggested I tried adding 
> a savepoint before the statement which might possible throw 
> unique constraint violation and on exception I am doing 
> rollback(savePoint).  
>  
> Unfortunately I can running into the same exception on 25P02 
> on executing rollback(savePoint).
>  
> I have included the sample code for reference.  Am I missing 
> something, or do I need to change any setting with postgres 
> database ?  Any suggestions are welcome.

What are these DAOs doing in the insert mathod?

Could you trace the statements that are actually sent to the
database server? Maybe that would shed light on the matter.

Yours,
Laurenz Albe

In response to

pgsql-jdbc by date

Next:From: Jesper PedersenDate: 2009-06-02 13:44:33
Subject: [Patch] Binary Transfer v12
Previous:From: Kris JurkaDate: 2009-06-02 00:23:59
Subject: Re: Patch to add a socketTimeout property. -- again

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