join table problem

vinay.nalla · **Joined:** Tue Dec 26, 2006 2:57 am **Posts:** 11

i've following tables..

LOGIN_TABLE
UID PK
EMP_ID
USERNAME
PASSWORD

ROLE_MASTER_TABLE
RM_ROLE_ID PK
RM_ROLE_DESC

USER_ROLE_TABLE
UR_UID PK, FK(refers LOGIN(UID))
UR_ROLE_ID FK(refers ROLE_MASTER(RM_ROLE_ID))

some one plz tell me how to write hibernate mappings for the above tables asap....

tenwit · **Joined:** Thu Dec 23, 2004 9:08 pm **Posts:** 2008

Did the refdocs not help you? You need a <set> (section 6.2) with a table="USER_ROLE_TABLE" attribute, containing a <key> (section 5.1.19) and a <one-to-many> (section 6.2.5) or <many-to-many> (6.2.4) association, as applicable.