Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. PersistenceBrokerTemplate.store() has thrown a SQLIntegrityConstraintViolationException
    Unsorted
    0
    0
    0
  2. Integrity Constraint Violation fix
    Oracle JDBC Driver
    18
    17
    6

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("KR"."KRIM_ENTITY_CACHE_T"."PRNCPL_ID")
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
52 frames hidden

Solution

Liam2 months ago

Below are two examples of this Exception.

Example Exception 1: Exception message: cannot insert NULL into ("MP_OWNER"."MP_TABLE"."BILL_YR")

  • Obtain the current integrity constraint (foreign key, primary key or unique key) from the table database.
  • Set the columns value in the insert statement to be a non-null value.

Example Exception 2: Exception message: unique constraint (CRUCIBLE.SYS_C009680) violated

  • Change the database table constraint to allow duplicates.
  • Or fix the insert or update statement so as to avoid duplicate and not to violate the unique constraint.

External results for this pattern (10)

  1. rrybalkinvia GitHub3 weeks ago
    ORA-02292: integrity constraint (SYSTEM.CT_VISITORS_FK_ASSOCIATION_ID) violated - child record found
    Show stack trace
  2. diogoabpvia GitHub2 months ago
    org.hibernate.exception.ConstraintViolationException: could not execute statement
    Show stack trace
  3. pubudupvia GitHub2 months ago
    Error occurred while updating the operation: 25 status:COMPLETED
    Show stack trace
  4. Prateekvia Stack Overflow2 months ago
    PreparedStatementCallback; SQL [INSERT INTO MP_TABLE(ACC_NUM, MY_YR,CRTE_DT,FILE_NAME) values (?,?,?,?) ORA-01400: cannot insert NULL into ("MP_OWNER"."MP_TABLE"."BILL_YR") ; nested exception is java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("MP_OWNER"."MP_TABLE"."BILL_YR")
    Show stack trace
  5. ORA-01400: cannot insert NULL into ("APS1"."E_GD_UTILFEE"."UTIL_ID")
    Show stack trace
  6. Cezary Zawadkavia Atlassian JIRA4 months ago
    could not insert: [com.atlassian.fisheye.user.model.RecentlyVisitedUser]
    Show stack trace
  7. Michael Bowermanvia Liferay Issues4 months ago
    org.springframework.dao.DataIntegrityViolationException: could not update: [com.liferay.portal.model.impl.ResourceBlockImpl#4006]; SQL [update ResourceBlock set mvccVersion=?, permissionsHash=? where resourceBlockId=? and mvccVersion=?]; constraint [GIPRTLE2.IX_AEEA209C]; nested exception is org.hibernate.exception.ConstraintViolationException: could not update: [com.liferay.portal.model.impl.ResourceBlockImpl#4006]
    Show stack trace
  8. Unknown authorvia javamonamour.org4 months ago
    ORA-00001: unique constraint (PP1_SOAINFRA.SYS_C0013550) violated
    Show stack trace
  9. Stevevia Stack Overflow4 months ago
    org.hibernate.exception.ConstraintViolationException: could not execute statement
    Show stack trace
  10. Beastvia Stack Overflow4 months ago
    could not execute statement
    Show stack trace