java.sql.SQLException: Primary or unique constraint required on main >> table: >> > VOTERS in statement [-- creating foreign key constraint >> > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT >> > absentee_ballo_registrant_i_FK FOREIGN KEY (registrant_id) REFERENCES >> > voters (id)]

empire-user | Francis De Brabandere | 4 years ago
  1. 0

    Re: Error creating FKs on HSQLDB with DBSQLScript.run

    empire-user | 4 years ago | Francis De Brabandere
    java.sql.SQLException: Primary or unique constraint required on main >> table: >> > VOTERS in statement [-- creating foreign key constraint >> > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT >> > absentee_ballo_registrant_i_FK FOREIGN KEY (registrant_id) REFERENCES >> > voters (id)]
  2. 0

    Re: Error creating FKs on HSQLDB with DBSQLScript.run

    empire-user | 4 years ago | Francis De Brabandere
    java.sql.SQLException: Primary or unique constraint required on main >> table: >> > VOTERS in statement [-- creating foreign key constraint >> > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT >> > absentee_ballo_registrant_i_FK FOREIGN KEY (registrant_id) REFERENCES >> > voters (id)]
  3. 0

    Mapping a table called "group" in Hibernate for DB2 and HSQLDB

    Stack Overflow | 7 years ago | Juha Syrjälä
    java.sql.SQLException: Unexpected token: GROUP in statement [create table group]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Java SQL-statement problems

    Stack Overflow | 3 years ago | iHank
    java.sql.SQLException: Column not found: HANK
  6. 0

    SimpleJdbcTestUtils.executeScript and multilines script

    Stack Overflow | 7 years ago | romaintaz
    java.sql.SQLException: Unexpected token: in statement [CREATE TABLE T_FOO (]

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

      Primary or unique constraint required on main >> table: >> > VOTERS in statement [-- creating foreign key constraint >> > absentee_ballo_registrant_i_FK -- ALTER TABLE absentee_ballots ADD CONSTRAINT >> > absentee_ballo_registrant_i_FK FOREIGN KEY (registrant_id) REFERENCES >> > voters (id)]

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.executeUpdate
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
      3 frames