Problem solved (I think)...
It appears that the FIRST ENTRIES in the schema-create.sql lines are ALTER TABLE ... DROP FOREIGN KEY...[i]. If the database is being created for the first time, the tables obviously don't exist, thus the errors. Running maven create-schema a SECOND time results in a series of [i]table already exists errors. When using mySQL, the resulting schema-create.sql has a series of -- SKIP drop table if exists ADDRESS_BOOK... -- SKIP drop table if exists BOOK2CONTENTS... ... Is there a reason those "drop tables" are commented out? Removing the "--SKIP" in front of each line results in a file that can be run (and re-run). Is this schema-create.sql file generated by AndroMDA, or by a Hibernate tool? _________________________________________________________ Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=2465#2465 Posting to http://forum.andromda.org/ is preferred over posting to the mailing list! ------------------------------------------------------- This SF.Net email is sponsored by the 'Do More With Dual!' webinar happening July 14 at 8am PDT/11am EDT. We invite you to explore the latest in dual core and dual graphics technology at this free one hour event hosted by HP, AMD, and NVIDIA. To register visit http://www.hp.com/go/dualwebinar _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user