java.sql.SQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL140616082752550' defined on 'PERSISTENTMESSAGE'. 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] Error Code: 20000 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] Call: INSERT INTO PERSISTENTMESSAGE (jobId, sequence, col, file, LEVEL, line, text, throwable, timestamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] bind => [9 parameters bound] 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] Query: InsertObjectQuery(org.daisy.pipeline.persistence.messaging.PersistentMessage@3c401d45) 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14

Google Groups | Greg Kearney | 3 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Trying, really trying to get Pipeline 2 to work

    Google Groups | 3 years ago | Greg Kearney
    java.sql.SQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL140616082752550' defined on 'PERSISTENTMESSAGE'. 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] Error Code: 20000 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] Call: INSERT INTO PERSISTENTMESSAGE (jobId, sequence, col, file, LEVEL, line, text, throwable, timestamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] bind => [9 parameters bound] 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] Query: InsertObjectQuery(org.daisy.pipeline.persistence.messaging.PersistentMessage@3c401d45) 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14
  2. 0

    When a flush method is issued right after a remove method in a one-to-many relationship causes a SQLIntegrityConstraintViolationException.

    Eclipse Bugzilla | 5 years ago | wwong
    java.sql.SQLIntegrityConstraintViolationException: Column 'NODEGROUPID' cannot accept a NULL value. Error Code: 20000 Call: UPDATE node SET nodeGroupID = ? WHERE (nodeID = ?) bind => [null, 105] Query: DeleteObjectQuery(Node[nodeId=105,nodes={[]},nodeGroupId=Nodegroup[nodes={[]},nodeGroupName=nodeGroupName_5,comment=comment_5,creatorId=5,creationTime=Tue May 08 16:13:59 EDT 2012,type=5,flags=5,nodeGroupId=97],proxyNodeId=persistence.jpa.entities.Node@557e5cbd,nodeName=nodeName_3,nodeAddress=nodeAddress_3,userName=userName_3,password=password_3,comment=comment_3,creatorId=3,creationTime=Tue May 08 16:16:49 EDT 2012,type=3,flags=3,features=3,hostId=hostId_3,policies={[]}])
  3. 0

    JPA2.0 CascadeType.ALL doesn't cascade persist

    Coderanch | 5 years ago | Jelo Nehuptra
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("LHS"."EXAMINEE"."ID_PERSON") Error Code: 1400 Call: INSERT INTO LHS.EXAMINEE (ID_PERSON, CLASSIFICATION, EXAM_DATE, INCOMING, RPM, SATNR, SCAT, SEE_NO, SLU_GIT, SLU_NVIT, SLU_VIT) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [11 parameters bound] Query: InsertObjectQuery(ph.edu.slu.lhs.sis.entity.Examinee[ idPerson=null ])
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    EclipseLink Generates Duplicate Primary Keys

    Stack Overflow | 4 years ago | sceaj
    java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (GAPM.SYS_C0033927) violated Error Code: 1 Call: INSERT INTO TIME_DIMENSION (ID, DAY_OF_MONTH, DAY_OF_WEEK, DAY_OF_YEAR, HOUR, JWK_WEEK, JWK_YEAR, MINUTE, MONTH, MONTH_NAME, QUARTER, WEEKDAY, YEAR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [3565649, 4, 1, 308, 19, 45, 2013, 7, 11, November, 2, Monday, 2013] Query: InsertObjectQuery(com.germainsoftware.apm.model.TimeDimension@14f272e7)
  6. 0

    What is wrong with the following code? It related to EclipseLink 2.1, JPA and Derby

    Stack Overflow | 5 years ago | Ajay
    java.sql.SQLIntegrityConstraintViolationException: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL120307183732430' defined on 'PARTYROLE'. Error Code: -1 Call: INSERT INTO PARTYROLE (ID, NAME, DTYPE) VALUES (?, ?, ?) bind => [0, CastingManager, CastingManager] Query: InsertObjectQuery(com.ats.data.partyrole.CastingManager@72f6f1b6)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLIntegrityConstraintViolationException

      The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL140616082752550' defined on 'PERSISTENTMESSAGE'. 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] Error Code: 20000 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] Call: INSERT INTO PERSISTENTMESSAGE (jobId, sequence, col, file, LEVEL, line, text, throwable, timestamp) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] bind => [9 parameters bound] 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14 [Pipeline 2 Engine console output] Query: InsertObjectQuery(org.daisy.pipeline.persistence.messaging.PersistentMessage@3c401d45) 2014-06-16 08:44:08,571 - [INFO] - from application in Thread-14

      at org.eclipse.persistence.exceptions.DatabaseException.sqlException()
    2. EclipseLink (non-OSGi)
      DatabaseException.sqlException
      1. org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324)
      1 frame