Re: JDBC behaviour

From: Sridhar N Bamandlapally <sridhar(dot)bn1(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: JDBC behaviour
Date: 2016-02-18 07:59:45
Message-ID: CAGuFTBUu51R=kbgjTgYLYFWkUSnoFo5jWO9E3T6fJW5UXTSgLA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vladimir Sitnikov 2016-02-18 08:13:39 Re: [JDBC] JDBC behaviour
Previous Message Sridhar N Bamandlapally 2016-02-18 07:52:53 JDBC behaviour

Browse pgsql-hackers by date

  From Date Subject
Next Message Vladimir Sitnikov 2016-02-18 08:13:39 Re: [JDBC] JDBC behaviour
Previous Message Sridhar N Bamandlapally 2016-02-18 07:52:53 JDBC behaviour

Browse pgsql-jdbc by date

  From Date Subject
Next Message Vladimir Sitnikov 2016-02-18 08:13:39 Re: [JDBC] JDBC behaviour
Previous Message Sridhar N Bamandlapally 2016-02-18 07:52:53 JDBC behaviour