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

Re: Reg: 25P02, current transaction is aborted, commands ignored until end of transaction block

From: ajay labade <ajaylabade(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: Reg: 25P02, current transaction is aborted, commands ignored until end of transaction block
Date: 2009-09-30 09:23:24
Message-ID: 25677673.post@talk.nabble.com (view raw or flat)
Thread:
Lists: pgsql-bugs


bhavani gade wrote:
> 
> Dear all,
> 
>     I am trying to port my application from Oracle to PostGREs. I have a
> problem while doing so. In my application i need to update record if the
> delete on the respective record is failed due to Constraint Violation. But
> SQL Error: 0, SQLState: 25P02 ERROR [JDBCExceptionReporter] ERROR: current
> transaction is aborted, commands ignored until end of transaction block is
> being generated while updating the record. But with Oracle i am able to do
> this.
> 
> I have tried with latest Jar [postgresql-8.3-604.jdbc3.jar] too, but
> problem still exists.
> 
> Here is the code that i worked on:
> 
> try{
>     session = sessionManager.getSession();
>     transaction = session.beginTransaction();
>     session.delete(objects[i]);
>     session.flush();
> }catch(ConstraintViolationException e){
>     objects[i].setDeleted(Integer.valueOf(1));
>     session.saveOrUpdate(object[i]);
>     session.flush();
> }
> transaction.commit();
> sessionManager.closeSession(session);
> 
> I am using platform java 1.5, jBoss 4.2.3, Hibernate v3.3, PostGREs v8.3
> and OS Windows me.
> 
> Thanks in advance,
> Bhavani.G
> 

-- 
View this message in context: http://www.nabble.com/Reg%3A-25P02%2C-current-transaction-is-aborted%2C-commands-ignored-until-end-of-transaction-block-tp22986191p25677673.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.


In response to

Responses

pgsql-bugs by date

Next:From: ajay labadeDate: 2009-09-30 09:26:29
Subject: Re: Reg: 25P02, current transaction is aborted, commands ignored until end of transaction block
Previous:From: Yamashkin AlexDate: 2009-09-30 08:33:15
Subject: BUG #5089: not supported plpsql

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