DB2 ERRORCODE=-4229, SQLSTATE=null

DB2 ERRORCODE=-4229, SQLSTATE=null

Search for 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 a batch execution.

User response: Call SQLException.getMessage to retrieve specific
information about the problem.

So, it might be related to any underlying error during the execution of your batch insert/update/delete

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

For me this was due to

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

DB2 ERRORCODE=-4229, SQLSTATE=null

In my case, this occurred because I had an unique covering index defined on two columns and the combination of these two values was not unique when I was inserting the records.

Leave a Reply

Your email address will not be published.