That was indeed the problem. Thanks, Rainer. On Fri, Jul 27, 2012 at 2:41 AM, Rainer Döbele <[email protected]> wrote:
> IMO this looks like there is no primary key defined for the VOTERS table.* > *** > > ** ** > > Please make sure that a primary key is set using setPrimaryKey(ID);**** > > ** ** > > Are you still having this problem or has it been solved?**** > > ** ** > > Regards**** > > Rainer**** > > ** ** > > *from:* Joel Becker [mailto:[email protected]] > *to:* [email protected] > *re:* Error creating FKs on HSQLDB with DBSQLScript.run**** > > ** ** > > Hi,**** > > ** ** > > 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 > **** > > ** ** > > Thanks,**** > > Joel**** > > ** ** >
