• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Foreign Key Must Have the Same Number Of Columns As the Referenced Primary Key

 
Lakshmeepathi Ghiree Anandh
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


I get the following error when <one-to-many>(Set) is used on a table with a composite-id. i.e when TYPE_ID in CALL_CENTER_TYPE_ASSOC table ,is not a part of composite-id, <one-to-many>(Set)
works.

Though it is <many-to-many>,I ll have only one object of CALL_CENTER_TYPE_ASSOC at a time.So,I thought <one-to-many> will retrieve multiple rows from
IM_CTIS_WORKFLOW_ASSOC.It worked when the column was not a part of composite-id.

I DO NOT HAVE THE COLUMN "CALL_CENTER_ID" AND I CANNOT ADD IT TO THE TABLE "IM_CTIS_WORKFLOW_ASSOC"

How do I get the same functionality when TYPE_ID is a part of composite-id? Please help. Thanks in advance.





Foreign key (FKDB7E233EB70B075B:IM_CTIS_WORKFLOW_ASSOC [TYPE_ID])) must have same number of columns as the referenced primary key (CALL_CENTER_TYPE_ASSOC [TYPE_ID,CALL_CENTER_ID])







 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic