Return Codes of BatchUpdateException in PostgreSql 9.6

From: Tillmann Schulz <tillmann73(at)yahoo(dot)de>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Return Codes of BatchUpdateException in PostgreSql 9.6
Date: 2016-10-12 10:23:57
Message-ID: 1828260214.7688612.1476267837715@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Hello,

I am migrating PostgreSql 9.5 to 9.6.0 and I am using the newest JDBC driver (9.4.1211.jre6)
So I am not sure if this is an driver issue or a bug in postgres.

We are making batch updates in our Java application.
Our JUnit Tests fail on 9.6 when querying the return code of a partially failed Bulk Update. In 9.5 everything works fine.

The following code is used:

private void handleBatchUpdateException(java.sql.BatchUpdateException x )
{
final int[] updateCounts = x.getUpdateCounts();

==> in 9.5 only ther failed updates have return code java.sql.Statement.EXECUTE_FAILED = -3. This is CORRECT.

==> in 9.6 all updatecounts have status java.sql.Statement.EXECUTE_FAILED = -3. This is NOT CORRECT.

What to do to get this bug fixed? Do you need more information?
Thank you for your response in advance.

Tillmann Schulz

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message John R Pierce 2016-10-12 10:39:20 Re: Return Codes of BatchUpdateException in PostgreSql 9.6
Previous Message Michael Paquier 2016-10-12 07:04:02 Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]',