All geek questions in one place

DB2 ERRORCODE = -4229, SQLSTATE = null

I get this error while performing a batch operation. Use getNextException() to retrieve the exceptions for specific batched elements.ERRORCODE=-4229, SQLSTATE=null

I do not find a pointer to debugging this error.

Appreciate any help !!!

+4
source share
3 answers

For those who are looking for a solution to this error.

For me it was connected with

THE INSERT OR UPDATE VALUE OF FOREIGN KEY constraint-name IS INVALID. DB2 SQL Error: SQLCODE=-530, SQLSTATE=23503

0
source

Find the error on the IBM page:

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.java%2Fsrc%2Ftpc%2Fimjcc_rjvjcsqc.htm

- 4229 Message text: text-from-getMessage Explanation: An error occurred during batch execution.

User Response: Call SQLException.getMessage to get specific information about the problem.

Thus, this could be due to any major error during the execution of your batch insert / update / delete

+3
source

In my case, this was because I had a unique coverage index defined in two columns, and the combination of these two values ​​was not unique when I inserted records.

0
source

Source: https://habr.com/ru/post/1495466/

More articles:


All Articles