I have some domain object mapped to a table in db, which has 'deleted_flag' property, designating whether record is logically deleted or not.
I want my application consider only 'not-deleted' objects from database, so that it will never be possible to load object with its deleted_Flag=true.

At the moment I have to run HQL, similar to the following:
"from MyObject obj where obj.deleted_flag = false and obj.id = ?'.

What I need to change in object mapping xml so that the same operation can be done thru simple session.load(MyObject.class, new Long(id) method?

The discriminator may do this kind of thing.

You could look at that article : http://www.onjava.com/lpt/a/6092

or the section 6.1.6 and 10.1.3 of the documentation:

6.1.6. discriminator

The <discriminator> element is required for polymorphic persistence using the table-per-class-hierarchy mapping strategy and declares a discriminator column of the table. The discriminator column contains marker values that tell the persistence layer what subclass to instantiate for a particular row. A restricted set of types may be used: string, character, integer, byte, short, boolean, yes_no, true_false.


Etienne

You should have a look at Hibernate filters:
http://www.hibernate.org/hib_docs/v3/re ... e/#filters

Best regards
Sven

Sven, I was considering the filters in Hibernate 3, however i found that filter is applied only to the object that is selected, not to its child/nested objects, i.e., and I don't know how to configure filter for inner object in general manner, so that it could be applied to it as if it will be retrieved along or in parent-child relationships.

you define the filter on the child collections also...

So, in general, I should paste filters whenever I need to apply them in class mapping file only
Is there any way to use a kind of inheritance of filters from child classes mapping ?