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
  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 | 8 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]
  6. 0

    RE: Task Scheduler not running ResetHitCountsTask and other tasks

    roller-user | 9 years ago | omar Martin Velasco
    org.apache.openjpa.persistence.PersistenceException: Data truncation: Incorrect datetime value: '1970-01-01 01:00:00' for column 'last_updated' at row 1 {prepstmnt 1777940648 INSERT INTO rag_subscription (id, author, feed_url, inbound_blogs, inbound_links, last_updated, site_url, title) VALUES (?, ?, ?, ?, ?, ?, ?, ?) [params=(String) d17711-6131-4765-b47e-1707cdd1f1b0, (String) New_Blog, (String) weblogger:blog, (int) 0, (int) 0, (Timestamp) 1970-01-01 01:00:00.0, (String) http://host/blog/, (String) New_Blog]} [code=0, state=01004] FailedObject: org.apache.roller.planet.pojos.Subscription@54806354

    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. 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