A question for jboss: a CMR field is the CMP field at the sa

[ygwangking]

I define three Entity Beans.Two beans have One to Many relationship with the third Bean.At the same time,two foreign key fields for that two beans in the third Bean are the unoin primary key of the third Bean. I can't create this relationship.
Because,in foreign key mapping,it can't defined that a CMR field is the CMP field at the same time.if that,it give me a exception:
ERROR [bbs_children_context] Could not create entity,java.sql.SQLException: General error: Column 'root_id' specified twice.
I think it is a question for JBoss.

[dsundstrom]

Correct you can't do that. You will have to have a seperate primay key and foreign key.

[ygwangking]

thank you.