I have the following problem:
Let's say I have a table with a composite primary key consisting of columns A and B. The same table has a composite foreign key consisting of columns B and C. Note that column B is shared between the PK and FK.
Setting up the PK is no problem at all, but the FK is causing trouble because it overlaps the PK. If I set up the foreign key with insert="false" update"false" then column C only contains nulls, If I omit the insert="false" update"false" then Hibernate complains about column B being declared twice. The XML schema won't let me specify insert="false" update"false" for column B but not C.
any suggestions?
|