Hibernate version:
NHibernate 1.0.2 / Releasedate 15-01-2006

Hi, when the inheritance tree is mapped as a joined-subclass mapping,
is it possible to specify a subclass within that hierarchy in the where clause of an HQL query? I've seen the "from Cat cat where cat.class=DomesticCat" variant, but that makes use of the discriminator value.

So if the inheritancetree looks like this

Instrument
|
Aerophone
| |
Clarinet Trumpet

mapped as joind-subclasses (taking up 4 tables),
I'd like to issue a query of the form "from Instrument i where i.class= Aerophone", that would return all Aerophones.

I know the "from Aerophone" query would return them also, I'd just like to know if there is a way to do it as described above.

Regards & TIA,

Willem van Rumpt

I need to know this as well. For a more complex query.

/Carl

the query is valid but unfortunately there is a bug in the HQL parser which prevents it to return the correct results. You should vote for this bug:
http://jira.nhibernate.org/browse/NH-571

more details here: http://forum.hibernate.org/viewtopic.php?t=957690&highlight=

cheers,
radu

Thanks for the info,
The number of votes has gone up by 1 :)

regards,
Willem van Rumpt