This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma 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


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: 204
    
    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();
 
Have you checked out Aspose?
 
subject: Hi everyone this is my very first post so please ignore any mistakes and let me know if any
 
It's not a secret anymore!