If that's the case then we should throw an exception to help the user fix this
F On 27 July 2012 09:41, 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 > >
