Hey everybody,

I have a class hierarchy (table per hierarchy) and would like to return only certain subclasses from this hierarchy that satisfy certain criteria.

Class hierarchy looks like this:
A -|
|-B
|-C
|-D
|-E

Let's assume that the superclass has a property called foo.

I need to return all subclasses of type B and C (but not D and E) where property foo has a value of 'bar'.

Is it possible to do?

Thanks,
-Dmitri

Looks like it is possible to do with an HQL query. Let's assume that discriminator column name is DISCRIMINATOR and its values are 'B', 'C', 'D' and 'E'. Then to select subclasses B and C with property foo set to bar:

from A where foo = bar and (DISCRIMINATOR='B' or DISCRIMINATOR='C')

Also, could someone explain why it is possible to use discriminator column in HQL queries, but impossible in criteria queries?

Cheers,
-Dmitri