File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Mapping same POJO to two tables in Hibernate XML mapping files Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Mapping same POJO to two tables in Hibernate XML mapping files" Watch "Mapping same POJO to two tables in Hibernate XML mapping files" New topic
Author

Mapping same POJO to two tables in Hibernate XML mapping files

Sreekanth Mogullapally
Greenhorn

Joined: Jul 21, 2010
Posts: 2


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
Ranch Hand

Joined: Nov 06, 2000
Posts: 1506
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>


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Sreekanth Mogullapally
Greenhorn

Joined: Jul 21, 2010
Posts: 2
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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Mapping same POJO to two tables in Hibernate XML mapping files
 
Similar Threads
Updaing image field in Sql server
Glassfish + jdbcrealm
Composite Foreign Key that maps to Unique Constraint
Hibernate many-to-one composite key as foreign key
JOIN syntax for HQL . Need help!