| 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: | Whole Thread | Raw Message | 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
| 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]', |