Hello,

I have a ClassA associated (many-to-one : "link" property) with ClassB which is derived in ClassC and ClassD

I would like to write a Criteria Query on the ClassA, and I want that the associated class be an instance of a particular class.

Something like

session.cretaeCriteria(ClassA.class).add(Restrictions.instanceOf("link", ClassC.class))

Of course the "instanceOf" restrictions doesn't exist but is there a way to do that (without sqlRestriction) ?

Thanks
Franck

session.createCriteria(ClassC.class)

But If I start the Criteria with this statement, I will obtain as result a collection of ClassC instances. Or I want a collection of ClassA instances.

Actually my workaround is :

criteria = session.createCriteria(ClassA.class)
criteria.createCriteria("link").add(Restrictions("{alias}.class =?", goodClass, Hibernate.String));

But I'm sure (?) there is a better way