Selective Loading of objects

relcom · **Joined:** Thu Feb 11, 2010 5:53 am **Posts:** 5

Hi,

I have a BusinessEntity -> Components relation that I have modelled in Hibernate. In our case, we dont really delete components but just mark one of the columns as true.

What I want is, when I do a get() in hibernate or during lazy loading of my components, to be able to retrieve only the rows that dont have the column deleted set as true.

I can ofcourse discard these at Java level, but if Hibernate provided some funtionality like this, it'd be more cleaner.

-thanks

littypreethkr · **Posted:** Thu Feb 25, 2010 7:30 am

Hi,

You can do:

Code:

@Entity
@Table(name = "TBL_NAME")
@Where(clause = "DELETED=0")
public class BusinessEntity {
   ........
   ........
}

Regards,
Litty Preeth

relcom · **Joined:** Thu Feb 11, 2010 5:53 am **Posts:** 5

thank you!

pb00067 · **Joined:** Tue Jun 16, 2009 3:36 am **Posts:** 990

Code:

@Entity
public class BusinessEntity {
    @OneToMany
    @Where(clause="deleted = false")
    private List<Components> enclosed;
}

Consider also this, maybe it fit's more what you require.