update报错ERRORCODE=-4229, SQLSTATE=null故障
DB2数据库在执行update操作时，经常如下错误信息，update失败，请大家帮忙诊断一下啦。
[2014-11-24 16:47:19,490][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[update TB_CON_CONTRACT set APPROVE_ID=?, CONTRACT_NUM=?, CONTRACT_MANUAL_NUM=?, CURRENCY_CD=?, CONTRACT_TOTAL_AMT=?, CONTRACT_TERM=?, CYCLE_UNIT=?, CONTRACT_SIGN_DATE=?, CONTRACT_SIGN_PLACE=?, START_DATE=?, EXPIRATION_DATE=?, CONTRACT_NATURE_CD=?, PRODUCT_TYPE=?, IF_CREDIT_DOWN_BUSINESS=?, IF_GOVERMENT_CREDIT=?, GOVERMENT_CREDIT_TYPE=?, IS_AGRICULTURE_LOANS=?, CREDIT_TYPE=?, FIXED_ASSETS_LOAN_TYPE=?, IS_PROJECT_FINANCING=?, LOAN_DIRECTION=?, BANK_HOUSE_CLASS_TYPE=?, BANK_SUPERVISOR_HOU_CLASS_TYPE=?, LOAN_USE=?, REPAY_SOURCE=?, SUPPLEMENTARY_PROVISIONS=?, RESTRICTIVE_CLAUSE=?, CREATE_TIME=?, UPDATE_TIME=?, PARTY_ID=?, LOAN_DIRECTION_TWO=?, IS_SUPPLY_CHAIN_BUSSINESS=?, AGRO_LOAN_TYPE=?, ORG_NUM=?, USER_NUM=?, IS_BANK_TEAM_LOAN=?, PRINCIPAL_REPAYMENT_TYPE=?, NEW_INDUSTRY_TYPE=?, CYCLE_FLAG=?, BIZ_HAPPEN_TYPE=?, IF_FIXED_ASSETS_LOAN=?, CONTRACT_BALANCE=?, PURPOSE_OF_LOAN_TYPE=?, PURPOSE_OF_LOAN=?, PLATFORM_PARTY_ID=?, LIMIT_CUS_NO=?, PROMISE_FEE_RATIO=? where CONTRACT_ID=?] execute error.
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.65.97] 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
[2014-11-24 16:47:19,494][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] [jcc][t4][102][10040][3.65.97] 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
[2014-11-24 16:47:19,494][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] [jcc][t4][102][10040][3.65.97] 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
[2014-11-24 16:47:19,497][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] Error for batch element #1: The current transaction was rolled back because of error "-911".. SQLCODE=-1476, SQLSTATE=40506, DRIVER=3.65.97
[2014-11-24 16:47:19,498][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] [jcc][103][10843][3.65.97] Non-recoverable chain-breaking exception occurred during batch processing. The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null
[2014-11-24 16:47:19,500][ERROR][com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener:301] Could not synchronize database state with session. Could not execute JDBC batch update
[2014-11-24 16:47:19,490][ERROR][com.primeton.common.connection.impl.synchronization.TraceLoggerStatementSynchronization:49] Sql[update TB_CON_CONTRACT set APPROVE_ID=?, CONTRACT_NUM=?, CONTRACT_MANUAL_NUM=?, CURRENCY_CD=?, CONTRACT_TOTAL_AMT=?, CONTRACT_TERM=?, CYCLE_UNIT=?, CONTRACT_SIGN_DATE=?, CONTRACT_SIGN_PLACE=?, START_DATE=?, EXPIRATION_DATE=?, CONTRACT_NATURE_CD=?, PRODUCT_TYPE=?, IF_CREDIT_DOWN_BUSINESS=?, IF_GOVERMENT_CREDIT=?, GOVERMENT_CREDIT_TYPE=?, IS_AGRICULTURE_LOANS=?, CREDIT_TYPE=?, FIXED_ASSETS_LOAN_TYPE=?, IS_PROJECT_FINANCING=?, LOAN_DIRECTION=?, BANK_HOUSE_CLASS_TYPE=?, BANK_SUPERVISOR_HOU_CLASS_TYPE=?, LOAN_USE=?, REPAY_SOURCE=?, SUPPLEMENTARY_PROVISIONS=?, RESTRICTIVE_CLAUSE=?, CREATE_TIME=?, UPDATE_TIME=?, PARTY_ID=?, LOAN_DIRECTION_TWO=?, IS_SUPPLY_CHAIN_BUSSINESS=?, AGRO_LOAN_TYPE=?, ORG_NUM=?, USER_NUM=?, IS_BANK_TEAM_LOAN=?, PRINCIPAL_REPAYMENT_TYPE=?, NEW_INDUSTRY_TYPE=?, CYCLE_FLAG=?, BIZ_HAPPEN_TYPE=?, IF_FIXED_ASSETS_LOAN=?, CONTRACT_BALANCE=?, PURPOSE_OF_LOAN_TYPE=?, PURPOSE_OF_LOAN=?, PLATFORM_PARTY_ID=?, LIMIT_CUS_NO=?, PROMISE_FEE_RATIO=? where CONTRACT_ID=?] execute error.
com.ibm.db2.jcc.am.BatchUpdateException: [jcc][t4][102][10040][3.65.97] 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
[2014-11-24 16:47:19,494][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] [jcc][t4][102][10040][3.65.97] 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
[2014-11-24 16:47:19,494][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] [jcc][t4][102][10040][3.65.97] 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
[2014-11-24 16:47:19,497][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] Error for batch element #1: The current transaction was rolled back because of error "-911".. SQLCODE=-1476, SQLSTATE=40506, DRIVER=3.65.97
[2014-11-24 16:47:19,498][ERROR][com.primeton.das.entity.impl.hibernate.util.JDBCExceptionReporter:77] [jcc][103][10843][3.65.97] Non-recoverable chain-breaking exception occurred during batch processing. The batch is terminated non-atomically. ERRORCODE=-4225, SQLSTATE=null
[2014-11-24 16:47:19,500][ERROR][com.primeton.das.entity.impl.hibernate.event.def.AbstractFlushingEventListener:301] Could not synchronize database state with session. Could not execute JDBC batch update