Hi all!
I use hibernate 2.1.4 on Linux with a MySQL 4.0.18 server. When I try to use the schema update tool then I get the following messages:
[schemaupdate] INFO: processing foreign key constraints
[schemaupdate] alter table HIB_ROLE_PROJECT_TIMESHEET add index FKC9EF7BE12A15E434 (FOREIGN_KEY), add constraint FKC9EF7BE12A15E434 foreign key (FOREIGN_KEY) references HIB_ENTITY_TIMESHEET (id)
[schemaupdate] 15.07.2004 15:11:13 net.sf.hibernate.tool.hbm2ddl.SchemaUpdate execute
[schemaupdate] SCHWERWIEGEND: Unsuccessful: alter table HIB_ROLE_PROJECT_TIMESHEET add index FKC9EF7BE12A15E434 (FOREIGN_KEY), add constraint FKC9EF7BE12A15E434 foreign key (FOREIGN_KEY) references HIB_ENTITY_TIMESHEET (id)
[schemaupdate] 15.07.2004 15:11:13 net.sf.hibernate.tool.hbm2ddl.SchemaUpdate execute
[schemaupdate] SCHWERWIEGEND: Invalid argument value, message from server: "Duplicate key name 'FKC9EF7BE12A15E434'"
[schemaupdate] alter table HIB_ROLE_PROJECT_TIMESHEET add index FKC9EF7BE1A738CA93 (OWNER_KEY), add constraint FKC9EF7BE1A738CA93 foreign key (OWNER_KEY) references HIB_ENTITY_PROJECT (id)
[schemaupdate] 15.07.2004 15:11:13 net.sf.hibernate.tool.hbm2ddl.SchemaUpdate execute
[schemaupdate] SCHWERWIEGEND: Unsuccessful: alter table HIB_ROLE_PROJECT_TIMESHEET add index FKC9EF7BE1A738CA93 (OWNER_KEY), add constraint FKC9EF7BE1A738CA93 foreign key (OWNER_KEY) references HIB_ENTITY_PROJECT (id)
...
Does anyone know how to fix or work around this?
Regards,
--Stefan
|