Hibernate version:3.2.5

All,

Need help in writing Criteria queries for Table Per Hierarchy Stratergy

Class & subclasses I have
Class : 'Vehicle' (discriminiator : V)
Subclass: 'LM Vehicle' (discriminiator : LMV)
Subclass: 'HM Vehicle' (discriminiator : HMV)
Subclass: 'HT Vehicle' (discriminiator : HTV)

Vehicle has an attribute 'power'.

If I want to query for all vehicle which has a power > 100bhp, my query would be
Criteria criteria = session.createCriteria(Vehicle.class);
criteria.addCriterion(Restrictions.gt("power", 100));
criteria.list();

<b>Now my question</b>
How do I query for only for LM Vehicle or HM Vehicles that has a power > 100bhp in one query?.
Criteria criteria = session.createCriteria(Vehicle.class);
//What to include in criteria, such that i can query on different vehicle types?.
criteria.addCriterion(Restrictions.gt("power", 100));
criteria.list();

Any suggestions/tips, No one has faced this problem?

you have to do query on the name of discriminator-column e.g. in your case discriminator column is "Vehicle_Type", then you will write HQL as follows

"from Vehicle where Vehicle_Type = HT"

for more details study the following blog. I m sure it will be helpful to you:

http://javainnovations.blogspot.com/2008/07/inheritance-strategy-class-per.html

Hi Amer,

Thanks for the reply, I'm looking at using Criteria API and not HQL for the query.