empire-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joel Becker (JIRA)" <empire-db-...@incubator.apache.org>
Subject [jira] [Created] (EMPIREDB-152) Error creating FKs on HSQLDB with DBSQLScript.run
Date Fri, 27 Jul 2012 14:24:33 GMT
Joel Becker created EMPIREDB-152:
------------------------------------

             Summary: Error creating FKs on HSQLDB with DBSQLScript.run
                 Key: EMPIREDB-152
                 URL: https://issues.apache.org/jira/browse/EMPIREDB-152
             Project: Empire-DB
          Issue Type: Bug
          Components: Core
    Affects Versions: empire-db-2.3.0
         Environment: Windows 7 64-bit, Java 6 64-bit
            Reporter: Joel Becker


(Originally a user mailing list post: http://mail-archives.apache.org/mod_mbox/empire-user/201207.mbox/browser)

I'm getting the following error when using DBSQLScript.run() to create an
HSQLDB database:

2012-07-25 15:22:42,471 [main] ERROR org.apache.empire.db.DBSQLScript  -
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)]
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(Unknown Source)
 at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.executeUpdate(Unknown Source)
 at
org.apache.empire.db.DBDatabaseDriver.executeSQL(DBDatabaseDriver.java:552)
at org.apache.empire.db.DBSQLScript.run(DBSQLScript.java:120)


Is the script being generated incorrectly?
This stackoverflow entry says it should be formatted differently:
http://stackoverflow.com/questions/10031613/hsql-error-when-attempting-to-create-foreign-key-constraint


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message