org.springframework.dao.DataIntegrityViolationException

PreparedStatementCallback; SQL [INSERT INTO TABLE1 (COL1, COL2, COL3 VALUES (?, ?, ?)]; DB2 SQL error: SQLCODE: -181, SQLSTATE: 22007, SQLERRMC: null; nested exception is com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -181, SQLSTATE: 22007, SQLERRMC: null

Solutions on the web526

  • via Spring JIRA by Jaime Sanchez, 11 months ago
    PreparedStatementCallback; SQL [INSERT INTO TABLE1 (COL1, COL2, COL3 VALUES (?, ?, ?)]; DB2 SQL error: SQLCODE: -181, SQLSTATE: 22007, SQLERRMC: null; nested exception is com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -181, SQLSTATE: 22007, SQLERRMC: null
  • via Spring JIRA by Jaime Sanchez, 1 year ago
    PreparedStatementCallback; SQL [INSERT INTO TABLE1 (COL1, COL2, COL3 VALUES (?, ?, ?)]; DB2 SQL error: SQLCODE: -181, SQLSTATE: 22007, SQLERRMC: null; nested exception is com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -181, SQLSTATE: 22007, SQLERRMC: null
  • via Spring JIRA by Hema Math, 1 year ago
    PreparedStatementCallback; SQL [INSERT into BATCH_JOB_INSTANCE(JOB_INSTANCE_ID, JOB_NAME, JOB_KEY, VERSION) values (?, ?, ?, ?)]; DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=IVA204X1;0000000202, DRIVER=3.53.70; nested exception is com.ibm.db2.jcc.b.zn: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=IVA204X1;0000000202, DRIVER=3.53.70
  • Stack trace

    • org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT INTO TABLE1 (COL1, COL2, COL3 VALUES (?, ?, ?)]; DB2 SQL error: SQLCODE: -181, SQLSTATE: 22007, SQLERRMC: null; nested exception is com.ibm.db2.jcc.a.SqlException: DB2 SQL error: SQLCODE: -181, SQLSTATE: 22007, SQLERRMC: null at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown user
    Once, 11 months ago