Can't create table errno 121 - duplicate FK
-------------------------------------------
Key: HIB-205
URL: http://jira.andromda.org/browse/HIB-205
Project: Hibernate Cartridge
Type: Bug
Versions: 3.2-RC1
Environment: linux fedora core 6
Reporter: Martin West
Assigned to: Carlos Cuenca
Theattached model generates an invalid schema due to duplicate FKs when a super
class has an association to another entity. On execution generates errors ...
[INFO] alter table CUSTOMER
add index PARTY_ADDRESS_FKC (ADDRESS_FK),
add constraint PARTY_ADDRESS_FKC
foreign key (ADDRESS_FK)
references ADDRESS (ID)
[INFO] alter table PARTY
add index PARTY_ADDRESS_FKC (ADDRESS_FK),
add constraint PARTY_ADDRESS_FKC
foreign key (ADDRESS_FK)
references ADDRESS (ID)
[WARNING] java.sql.SQLException: Can't create table
'./myaccounts/#sql-b09_12.frm' (errno: 121)
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.andromda.org/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV