Mapping same POJO to two tables in Hibernate XML mapping files

[Sreekanth Mogullapally]

I have below two tables. How should i map in a single mapping file withy single POJO Class.

create table Table1 (
id INTEGER NOT NULL,
code varchar(50) not null,
PRIMARY KEY (id)
);

create table Table2(
id INTEGER NOT NULL,
seq_number INTEGER NOT NULL,
description varchar(50) NOT NULL,
PRIMARY KEY (id,seq_number),
foreign key(id) references Table1(id)
);


Please help me in this regard.

[Bosun Bello]

You can by specifying the join table

# <class name="Emp" table="EMP">
# <id name="id" column="EMP_ID">...</id>
# ...
# <join table="ADDRESS">
# <key column="EMP_ID"/>
# <property name="addrLine1"/>
# <property name="city"/>
# </join>

[Sreekanth Mogullapally]

Thankx for your quick reply.

But here the problem is the table i need to join is having composite primary key in that one column is referenced to parent table.

How should i mention this composite primary key in join tag?