Can not create Table with Many to Many relationships ---------------------------------------------------- Key: HHH-3076 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3076 Project: Hibernate3 Issue Type: Bug Affects Versions: 3.2.5 Environment: Hibernate 3.2.5 HSQL DB for Unit Testing Hibernate Annotations with Spring Reporter: Farooq Ahmad Hi I am getting following error while using @ManytoMany relationships. Interesting thing is that my all unit tests are working fine. **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table ClueGiver add constraint FK7E948E28D7D12F96 foreign key (id) references Interactor **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table ClueGiver add constraint FK7E948E28D7D12F96 foreign key (id) references Interactor] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Emoticon add constraint FK49B622A68A1F97CD foreign key (AVAT_ID) references Avatar **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table Emoticon add constraint FK49B622A68A1F97CD foreign key (AVAT_ID) references Avatar] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Interactor add constraint FK1744CAB9E1ED9A42 foreign key (information_fk) references Information **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table Interactor add constraint FK1744CAB9E1ED9A42 foreign key (information_fk) references Information] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Inventory_InventoryItem add constraint FK23935CAC15C312C3 foreign key (inventoryItems_id) references InventoryItem **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table Inventory_InventoryItem add constraint FK23935CAC15C312C3 foreign key (inventoryItems_id) references InventoryItem] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Inventory_InventoryItem add constraint FK23935CACE9836C18 foreign key (Inventory_id) references Inventory **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table Inventory_InventoryItem add constraint FK23935CACE9836C18 foreign key (Inventory_id) references Inventory] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestAcceptor add constraint FK29C94BCDD7D12F96 foreign key (id) references Interactor **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table QuestAcceptor add constraint FK29C94BCDD7D12F96 foreign key (id) references Interactor] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestAcceptor_Reward add constraint FK4CB17C01BC814F98 foreign key (QuestAcceptor_id) references QuestAcceptor **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table QuestAcceptor_Reward add constraint FK4CB17C01BC814F98 foreign key (QuestAcceptor_id) references QuestAcceptor] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestAcceptor_Reward add constraint FK4CB17C0130F29C27 foreign key (rewards_id) references Reward **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table QuestAcceptor_Reward add constraint FK4CB17C0130F29C27 foreign key (rewards_id) references Reward] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestGiver add constraint FK97D307DFD7D12F96 foreign key (id) references Interactor **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table QuestGiver add constraint FK97D307DFD7D12F96 foreign key (id) references Interactor] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestParty_Avatar add constraint FK95530AD4405638B1 foreign key (questPartys_id) references QuestParty **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table QuestParty_Avatar add constraint FK95530AD4405638B1 foreign key (questPartys_id) references QuestParty] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestParty_Avatar add constraint FK95530AD498005B7B foreign key (avatars_id) references Avatar **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table QuestParty_Avatar add constraint FK95530AD498005B7B foreign key (avatars_id) references Avatar] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestParty_Quest add constraint FK5B23407405638B1 foreign key (questPartys_id) references QuestParty **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table QuestParty_Quest add constraint FK5B23407405638B1 foreign key (questPartys_id) references QuestParty] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestParty_Quest add constraint FK5B23407B51E1009 foreign key (quests_id) references Quest **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table QuestParty_Quest add constraint FK5B23407B51E1009 foreign key (quests_id) references Quest] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Quest_ClueGiver add constraint FKD4BF26EB1012D8F5 foreign key (clueGivers_id) references ClueGiver **** 01-21@10:47:07 ERROR (SchemaExport.java:275) - Unexpected token: ALTER in statement [alter table Quest_ClueGiver add constraint FKD4BF26EB1012D8F5 foreign key (clueGivers_id) references ClueGiver] **** 01-21@10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Quest_ClueGiver add constraint FKD4BF26EBB51E1009 foreign key (quests_id) references Quest Best regards Farooq ahmad -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira