This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Hi everyone this is my very first post so please ignore any mistakes and let me know if any Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hi everyone this is my very first post so please ignore any mistakes and let me know if any" Watch "Hi everyone this is my very first post so please ignore any mistakes and let me know if any" New topic
Author

Hi everyone this is my very first post so please ignore any mistakes and let me know if any

mahesh shastri
Greenhorn

Joined: Sep 04, 2010
Posts: 11

I am using Hibernate and postgrSQL in my project . I am in a situation where I need to do self-join for a table and I want to use
one- to-many relationship for that. Where my table contains few fields in which one of the field say x field contains the value of
primary key which can be null. Now sometimes I need to fetch records which have identical values in field x.
how do i configure this in hbm.xml ?


Thanks and Regards
Sai Hegde
security forum advocate
Ranch Hand

Joined: Oct 26, 2010
Posts: 200
    
    1

Use DetachedCriteria for the object and set the projection for the join field.

Code Snippet -

DetachedCriteria dc = DetachedCriteria.forClass(Table.class);
dc.add(Restrictions.eq("x", value1);
dc.setProjection(Property.forName("y"));
Criteria c = session.createCriteria(Table.class);

c.add(Property.forName("y").in(dc));
c.list();
 
wood burning stoves
 
subject: Hi everyone this is my very first post so please ignore any mistakes and let me know if any