• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Bear Bibeault
  • Ron McLeod
  • Jeanne Boyarsky
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Liutauras Vilda
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • fred rosenberger
  • salvin francis
Bartenders:
  • Piet Souris
  • Frits Walraven
  • Carey Brown

DB2 duplicate rows error code

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello.

When I want to insert a duplicate row in a table from a console/tool (e.g.: DB Visualizer) I get the following error message:

[Error Code: -803, SQL State: 23505] AN INSERTED OR UPDATED VALUE IS INVALID BECAUSE INDEX IN INDEX SPACE IDXR1PXX CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS. RID OF EXISTING ROW IS X'0000000301'.. SQLCODE=-803, SQLSTATE=23505, DRIVER=3.57.82
which is OK.

When I want to run the same query from a Java application using PreparedStatement.executeBatch() (batch because it could insert more than one row at a time) I get a different error message:
com.ibm.db2.jcc.am.wn: [jcc][t4][102][10040][3.57.82] Batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4228, SQLSTATE=null
com.ibm.db2.jcc.am.co: A NON-ATOMIC INSERT STATEMENT ATTEMPTED TO PROCESS MULTIPLE ROWS OF DATA, BUT ERRORS OCCURRED

and the error code is -4228

Why this difference? Did I do something wrong?

I use DB2 version 9 on z/OS (DSN09015) and the DB2 driver version is 3.57.82

Any help would be appreciated!
 
Ranch Hand
Posts: 451
1
IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Check the error:

INDEX IN INDEX SPACE IDXR1PXX CONSTRAINS COLUMNS OF THE TABLE SO NO TWO ROWS CAN CONTAIN DUPLICATE VALUES IN THOSE COLUMNS



Have a look at the data you probably are trying to insert a value in those columns that results in a duplicate.

Cheers,
Raj.
 
Nairpic Tol
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The data is fine. I intentionally want to insert a row that already exists in the table and I expect to have the -803 error code returned, but instead, in the Java application, I get a different error code: -4228

The Java application behaves as expected on Oracle and MSSQL databases and there it returns the error codes that are expected in case of duplicated row error ( 2601 for MSSQL and 1 for Oracle). The problem is on a DB2 database where it should return -803 but instead it returns -4228.

Thanks.
 
Everyone is a villain in someone else's story. Especially this devious tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic