Re: JDBC behaviour - Mailing list pgsql-jdbc

From Sridhar N Bamandlapally
Subject Re: JDBC behaviour
Date
Msg-id CAGuFTBUu51R=kbgjTgYLYFWkUSnoFo5jWO9E3T6fJW5UXTSgLA@mail.gmail.com
Whole thread Raw
In response to JDBC behaviour  (Sridhar N Bamandlapally <sridhar.bn1@gmail.com>)
Responses Re: JDBC behaviour
List pgsql-jdbc
Hi

We are facing issue with PostgreSQL JDBC behaviour

in Java, under autocommit false mode, 

1. In between if any transaction then for next transaction, throws exception saying "current transaction is aborted, commands ignored until end of transaction block"

2. Even if exception is suppressed with try-catch then too for next transaction, throws exception saying "current transaction is aborted, commands ignored until end of transaction block"

3. The same is not happening with Oracle or SQL-Server, in this with-out any exception handling it works

Is it a bug or do we have other any alternate way to handle this ?

Please I need some help in this

Thanks
Sridhar


pgsql-jdbc by date:

Previous
From: Sridhar N Bamandlapally
Date:
Subject: JDBC behaviour
Next
From: Vladimir Sitnikov
Date:
Subject: Re: JDBC behaviour