Hi,

can anyone tell me , How to manage associations between the following tables? and how to map them in xxxx.hbm.xml file ?

CREATE TABLE part(
Part_no NUMBER PRIMARY KEY,
Part_desc VARCHAR2(200) NOT NULL );

CREATE TABLE item (
Item_no NUMBER,
Part_no NUMBER,
Item_desc varchar2(200) NOT NULL,
CONSTRAINT fk_item_part FOREIGN KEY (part_no) REFERENCES PART (part_no),
CONSTRAINT pk_item PRIMARY KEY (item_no, part_no) );

Regards,
Srinivas

If you're struggling with the mapping, you might want to look at Hibernate Tools. There are eclipse plug-ins that will do this type of bottom-up database mapping for you, and create the hbm files you need.