Win a copy of React Cookbook: Recipes for Mastering the React Framework this week in the HTML Pages with CSS and JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Rob Spoor
  • Liutauras Vilda
Sheriffs:
  • Jeanne Boyarsky
  • Junilu Lacar
  • Tim Cooke
Saloon Keepers:
  • Tim Holloway
  • Piet Souris
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Frits Walraven
  • Himai Minh

Mapping same POJO to two tables in Hibernate XML mapping files

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator


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.
 
Ranch Hand
Posts: 1512
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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?
 
Can you shoot lasers out of your eyes? Don't look at this tiny ad:
the value of filler advertising in 2021
https://coderanch.com/t/730886/filler-advertising
reply
    Bookmark Topic Watch Topic
  • New Topic