[DB2] Use getNextException() to retrieve the exceptions for specific batched elements. ERRORCODE=-4229, SQLSTATE=null

Problem

When I using Apache Commons DBUtils to do batch insert data into IBM DB2, I get this SQLException:

1 2 3

SQL Message: [jcc][t4][102][10040][4.14.88] 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=-4229, SQLSTATE=null

Code Snippet:

1 2 3 4 5 6 7 8 9 10 11 12 13 14

/** * 批次處理. * * @param sql * insert/update/delete sql statemet * @param params * parameters * @throws SQLException * in case of fail to do insert/update/delete */ public void batchUpdate(String sql, Object[][] params) throws SQLException { QueryRunner run = new QueryRunner(); run.batch(this.getConnection(), sql, params); }

How-To
According to the troubleshooting information from IBM Support, it said:

The error is caused by the DB2 Transaction log for the Data Warehouse becoming full and not able to process the full batch operation.

But the root case is "value too large" in insert SQL statement, having nothing to do with DB2 Transaction log.