org.apache.openjpa.persistence.PersistenceException: The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 {prepstmnt 701376974 INSERT INTO bookmark (id, description, feedurl, image, name, priority, url, weight, folderid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) 43638a80-354d-4caf-8c3e-f6ecb7d4fcb1, (String) , (null) null, (null) null, (String) Lance Lavandowska, (int) 0, (String) http://rollerweblogger.org/lance, (int) 0, (String) c26615a2-cb52-4f28-aa6c-3ad76d4874e7]} [code=-530, state=23503]SQLCA OUTPUT[Errp=SQLRI079, Errd=-2145779603, 0, 0, 0, -100, 0] The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 FailedObject: org.apache.roller.weblogger.pojos.WeblogBookmark@21e321e3

roller-user | (David) Ming Xia | 8 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    I got database error on Roller 4.0.1

    roller-user | 8 years ago | (David) Ming Xia
    org.apache.openjpa.persistence.PersistenceException: The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 {prepstmnt 701376974 INSERT INTO bookmark (id, description, feedurl, image, name, priority, url, weight, folderid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) 43638a80-354d-4caf-8c3e-f6ecb7d4fcb1, (String) , (null) null, (null) null, (String) Lance Lavandowska, (int) 0, (String) http://rollerweblogger.org/lance, (int) 0, (String) c26615a2-cb52-4f28-aa6c-3ad76d4874e7]} [code=-530, state=23503]SQLCA OUTPUT[Errp=SQLRI079, Errd=-2145779603, 0, 0, 0, -100, 0] The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 FailedObject: org.apache.roller.weblogger.pojos.WeblogBookmark@21e321e3
  2. 0

    I got database error on Roller 4.0.1

    roller-user | 8 years ago | (David) Ming Xia
    org.apache.openjpa.persistence.PersistenceException: The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 {prepstmnt 701376974 INSERT INTO bookmark (id, description, feedurl, image, name, priority, url, weight, folderid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) 43638a80-354d-4caf-8c3e-f6ecb7d4fcb1, (String) , (null) null, (null) null, (String) Lance Lavandowska, (int) 0, (String) http://rollerweblogger.org/lance, (int) 0, (String) c26615a2-cb52-4f28-aa6c-3ad76d4874e7]} [code=-530, state=23503]SQLCA OUTPUT[Errp=SQLRI079, Errd=-2145779603, 0, 0, 0, -100, 0] The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 FailedObject: org.apache.roller.weblogger.pojos.WeblogBookmark@21e321e3
  3. 0

    Entitymanager.persist rows all NULL (EJB and other Java EE Technologies forum at Coderanch)

    coderanch.com | 12 months ago
    org.apache.openjpa.persistence.PersistenceException: Field 'firstname' doesn't have a default value {prepstmnt 1072250857 INSERT INTO user_details () VALUES ()} [code=1364, state=HY000] FailedObject: com.myapp.business.dao.UserRegistrationDao@3d3e3d3e
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    problem in persisting object using jpa

    Stack Overflow | 6 years ago | akshay
    org.apache.openjpa.persistence.PersistenceException: DB2 SQL Error: SQLCODE=-407, SQLSTATE=23502, SQLERRMC=TBSPACEID=2, TABLEID=517, COLNO=1, DRIVER=3.50.152 FailedObject: prepstmnt 154143024 INSERT INTO XYZ (empid, empname,CREATE_TS, UPDT_TS) VALUES (?, ?, ?, ?) [org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement]

    Root Cause Analysis

    1. org.apache.openjpa.persistence.PersistenceException

      The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 {prepstmnt 701376974 INSERT INTO bookmark (id, description, feedurl, image, name, priority, url, weight, folderid) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(String) 43638a80-354d-4caf-8c3e-f6ecb7d4fcb1, (String) , (null) null, (null) null, (String) Lance Lavandowska, (int) 0, (String) http://rollerweblogger.org/lance, (int) 0, (String) c26615a2-cb52-4f28-aa6c-3ad76d4874e7]} [code=-530, state=23503]SQLCA OUTPUT[Errp=SQLRI079, Errd=-2145779603, 0, 0, 0, -100, 0] The insert or update value of the FOREIGN KEY "DAVIDXIA.BOOKMARK.BM_FOLDERID_FK" is not equal to any value of the parent key of the parent table.. SQLCODE=-530, SQLSTATE=23503, DRIVER=3.50.152 FailedObject: org.apache.roller.weblogger.pojos.WeblogBookmark@21e321e3

      at org.apache.openjpa.jdbc.sql.DBDictionary.narrow()
    2. OpenJPA Aggregate Jar
      BatchingConstraintUpdateManager.flush
      1. org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4232)
      2. org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4197)
      3. org.apache.openjpa.jdbc.sql.DB2Dictionary.newStoreException(DB2Dictionary.java:503)
      4. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:102)
      5. org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:72)
      6. org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:131)
      7. org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.batchOrExecuteRow(BatchingPreparedStatementManagerImpl.java:102)
      8. org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:86)
      9. org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:89)
      10. org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:72)
      11. org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:543)
      12. org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:105)
      13. org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
      13 frames
    3. com.ibm.ws
      ConstraintUpdateManager.flush
      1. com.ibm.ws.persistence.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:78)
      2. com.ibm.ws.persistence.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:60)
      2 frames
    4. OpenJPA Aggregate Jar
      DelegatingStoreManager.flush
      1. org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:655)
      2. org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:130)
      2 frames