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

    Re: Error creating FKs on HSQLDB with DBSQLScript.run

    empire-user | 5 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 | 5 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

    Trying to deploy Railo as war file | JBoss Developer

    jboss.org | 9 months ago
    java.sql.SQLException: Table already exists: JBM_DUAL in statement [CREATE TABLE JBM_DUAL]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

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

    Java SQL-statement problems

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

    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