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

    Re: Error creating FKs on HSQLDB with DBSQLScript.run

    empire-user | 5 years ago | Joel Becker
    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 | Joel Becker
    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 | 7 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