Re: Return Codes of BatchUpdateException in PostgreSql 9.6

From: Tillmann Schulz <tillmann73(at)yahoo(dot)de>
To: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Return Codes of BatchUpdateException in PostgreSql 9.6
Date: 2016-10-18 13:14:58
Message-ID: 2090140889.4873532.1476796498454@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

After debugging my problem with the updateCount in the 9.4.1211 JDBC Driver I found the line in the code which causes the error.

It's

org.postgresql.jdbc.BatchResultHandler, Line 138 , JDBC Driver postgresql-9.4.1211

@Override
public void handleError(SQLException newError) {
if (getException() == null) {
Arrays.fill(updateCounts, committedRows, updateCounts.length, Statement.EXECUTE_FAILED); //138 <-- BUG
//...

Before the line "Arrays.fill..." the updateCounts contain the information of the already successfully inserted records [1,1,1,1,1,0,0,0,0,0].
After filling the array with Statement.EXECUTE_FAILED the array contains [-3,-3,-3,-3,-3,-3,-3,-3,-3,-3]
This is a not correct.
The correct result is [1,1,1,1,1] or [1,1,1,1,1,-3]

How to get this bug fixed? Can you rethink your implementation?

Thank you for your help,

Tillmann

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Enrico Olivelli - Diennea 2016-10-19 09:24:15 Re: Return Codes of BatchUpdateException in PostgreSql 9.6
Previous Message Tillmann Schulz 2016-10-17 07:13:47 Re: Return Codes of BatchUpdateException in PostgreSql 9.6