How can i create hbm mapping for a scenario of Forigen key to Composit primary Key. below is the problem defination. I have 2 tables one table has 3 columns, all 3 columns are part of composit key. Another table has 2 columns and all the 2 columns are part of composit key.
ITEM_TABLE USER_ID, DEPARTMENT, ITEM_TYPE
USER_ID, DEPARTMENT, ITEM_TYPE are composit keys.
USER_TABLE USER_ID, DEPARTMENT
USER_ID, DEPARTMENT are composit keys.
How to create relation between ITEM_TABLE and USER_TABLE. I am using Hibernate 3.1