[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3076) Can not create Table with Many to Many relationships

Farooq Ahmad (JIRA) noreply at atlassian.com
Mon Jan 21 05:06:55 EST 2008 

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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table ClueGiver add constraint FK7E948E28D7D12F96 foreign key (id) references Interactor
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Emoticon add constraint FK49B622A68A1F97CD foreign key (AVAT_ID) references Avatar
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Interactor add constraint FK1744CAB9E1ED9A42 foreign key (information_fk) references Information
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Inventory_InventoryItem add constraint FK23935CAC15C312C3 foreign key (inventoryItems_id) references InventoryItem
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Inventory_InventoryItem add constraint FK23935CACE9836C18 foreign key (Inventory_id) references Inventory
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestAcceptor add constraint FK29C94BCDD7D12F96 foreign key (id) references Interactor
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestAcceptor_Reward add constraint FK4CB17C01BC814F98 foreign key (QuestAcceptor_id) references QuestAcceptor
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestAcceptor_Reward add constraint FK4CB17C0130F29C27 foreign key (rewards_id) references Reward
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestGiver add constraint FK97D307DFD7D12F96 foreign key (id) references Interactor
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestParty_Avatar add constraint FK95530AD4405638B1 foreign key (questPartys_id) references QuestParty
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestParty_Avatar add constraint FK95530AD498005B7B foreign key (avatars_id) references Avatar
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestParty_Quest add constraint FK5B23407405638B1 foreign key (questPartys_id) references QuestParty
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table QuestParty_Quest add constraint FK5B23407B51E1009 foreign key (quests_id) references Quest
**** 01-21 at 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 at 10:47:07 ERROR (SchemaExport.java:274) - Unsuccessful: alter table Quest_ClueGiver add constraint FKD4BF26EB1012D8F5 foreign key (clueGivers_id) references ClueGiver
**** 01-21 at 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 at 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.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

More information about the hibernate-issues mailing list