Return Codes of BatchUpdateException in PostgreSql 9.6

Поиск
Список
Период
Сортировка
От Tillmann Schulz
Тема Return Codes of BatchUpdateException in PostgreSql 9.6
Дата
Msg-id 614642043.9384313.1476347124138@mail.yahoo.com
обсуждение исходный текст
Ответы Re: Return Codes of BatchUpdateException in PostgreSql 9.6
Список pgsql-jdbc
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 Batch Update.

If a statement of a batch update fails, all updateCounts are marked as failed.

In 9.5 everything works fine.

I try to give an example:

Preparation, with SQL
-----------------------------
create table TESTTABLE(id integer PRIMARY KEY) ;

INSERT INTO TESTTABLE VALUES (5);


Java Code with Java JDBC Update
-----------------------------

try{
   for( int i = 0; i < 10;i++ )
      {
    stmt.addBatch("INSERT INTO TESTTABLE VALUES('"+i+"')"    );
   }
      stmt.executeBatch();
   con.commit();
}
catch( 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.
}



In the sample, the 6th statement has an error, because the value 5 already exists in the database.

In this case in postgres 9.6 all fields updateCounts[0..9] are -3 (Statement.EXECUTE_FAILED)
The behavior prior 9.6 was, that only the specific entry in updateCounts[5] has the error code -3



Thank you for your help

Tillmann Schulz

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Tillmann Schulz
Дата:
Сообщение: Return Codes of BatchUpdateException in PostgreSql 9.6
Следующее
От: rob stone
Дата:
Сообщение: Re: Return Codes of BatchUpdateException in PostgreSql 9.6