com.solarmetric.jdbc.ReportingSQLException: ORA-02291: integrity constraint (VAMP.ADRESSE_PS) violated - parent key not found {prepstmnt 22511833 INSERT INTO VAMP.ADRESSE (ADRESSART, EMAIL, FAXNR, ID, MANDANTID, MELDEADRESSE, MOBILNR, ORT, PERSONID, PLZ, POSTADRESSE, POSTFACH, STRASSE, TELEFONNR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(int) 1, (String) m.horstmann@yahoo.de, (String) 04941 183742, (int) 12761, (int) 1, (int) 1, (String) 0171 2846751, (String) Oldenburg, (int) 12760, (String) 26129, (int) 1, (null) null, (String) Ammerl__nder Heerstra__e 19, (String) 04941 183740] [reused=0]} [code=2291, state=23000]

Oracle Community | 3004 | 1 decade ago
  1. 0

    wrong order foreign key constraints

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ORA-02291: integrity constraint (VAMP.ADRESSE_PS) violated - parent key not found {prepstmnt 22511833 INSERT INTO VAMP.ADRESSE (ADRESSART, EMAIL, FAXNR, ID, MANDANTID, MELDEADRESSE, MOBILNR, ORT, PERSONID, PLZ, POSTADRESSE, POSTFACH, STRASSE, TELEFONNR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(int) 1, (String) m.horstmann@yahoo.de, (String) 04941 183742, (int) 12761, (int) 1, (int) 1, (String) 0171 2846751, (String) Oldenburg, (int) 12760, (String) 26129, (int) 1, (null) null, (String) Ammerl__nder Heerstra__e 19, (String) 04941 183740] [reused=0]} [code=2291, state=23000]
  2. 0

    Oracle CLOB problem

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: ORA-01407: cannot update ("AAA"."CONTRACT_HISTORY"."EVENT_DESCRIPTION") to NULL {prepstmnt 159208982 UPDATE AAA.CONTRACT_HISTORY SET EVENT_DESCRIPTION = ?, LAST_UPDATE_DATE = ?, CONTRACT_ID = ? WHERE CONTRACT_HISTORY_ID = ? AND SEQ_NUMBER = ? [params=(Reader) java.io.StringReader@9799616, (Timestamp) 2004-12-17 14:51:06.394, (long) 640, (long) 4, (long) 4]} [code=1407, state=72000]
  3. 0

    cannot write to the database

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'key, value) VALUES ('test', '50')' at line 1 {prepstmnt 849515 INSERT INTO ns_config (key, value) VALUES (?, ?) [reused=0]} [code=1064, state=42000]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Datetime field overflow in DB2 with Kodo 3.0.3

    Oracle Community | 1 decade ago | 3004
    com.solarmetric.jdbc.ReportingSQLException: [IBM][CLI Driver] CLI0114E Datetime field overflow. SQLSTATE=22008 {prepstmnt 17678065 INSERT INTO COR.T_PROJECTCOST (AMOUNT_F, APPROVALINFO_VC, BILLABLE_B, DATE_DT, DESCRIPTION_VC, ID_I, NAME_VC, PROJECTCOSTTYPE_ID_I, PROJECT_ID_I, ROWVERSION_I) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [reused=0]} [code=-99999, state=22008]
  6. 0

    Update failed when trying to update a nested object

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot insert explicit value for identity column in table 'SessionType' when IDENTITY_INSERT is set to OFF.

    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. com.solarmetric.jdbc.ReportingSQLException

      ORA-02291: integrity constraint (VAMP.ADRESSE_PS) violated - parent key not found {prepstmnt 22511833 INSERT INTO VAMP.ADRESSE (ADRESSART, EMAIL, FAXNR, ID, MANDANTID, MELDEADRESSE, MOBILNR, ORT, PERSONID, PLZ, POSTADRESSE, POSTFACH, STRASSE, TELEFONNR) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=(int) 1, (String) m.horstmann@yahoo.de, (String) 04941 183742, (int) 12761, (int) 1, (int) 1, (String) 0171 2846751, (String) Oldenburg, (int) 12760, (String) 26129, (int) 1, (null) null, (String) Ammerl__nder Heerstra__e 19, (String) 04941 183740] [reused=0]} [code=2291, state=23000]

      at com.solarmetric.jdbc.LoggingConnectionDecorator.wrap()
    2. com.solarmetric.jdbc
      DelegatingPreparedStatement.executeUpdate
      1. com.solarmetric.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:124)
      2. com.solarmetric.jdbc.LoggingConnectionDecorator.access$600(LoggingConnectionDecorator.java:19)
      3. com.solarmetric.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:728)
      4. com.solarmetric.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:362)
      4 frames