Hi,

I'm new to Hibernate and am wondering if the following query is possible with Hibernate's OQL or HQL:

Here is my object model:

C-M------1-B-M------1-A
|
/\
--
|
D

i.e. A has a 1-M association with B, B has a 1-M association with C and
D is one subclass of C

The query that I like to perform is this:

find all A's with aAttribute = "foo" AND
having a C with cAttribute = "bar" AND
having a D with dAttribute = "foobar".

Of course, it would be nice if the query could translate into one SQL statement.

Your response would be most appreciated,

Phil

For sure, not until 2.2 (in cvs only).

Thanks. What would the HQL look like? Does this work in the current cvs head?

Phil

Hibernate v22branch is not even alpha, it doesn't work with current versions.

select a from A as a join a.Bs as b join b.Cs as c where a.attribA = "foo" and c.attribC = "bar" and <don't have class casts yet>.attribD = "baz" would be the syntax.

Is it the ability to cast that is going to be available in 2.2 and is that what Emmanuel was referring to?

Phil

We had a discussion about the cast in HQL on the developer list last week, yes, it will be in a future release. I don't know what Emmanuel is talking about either ;)

Yes, I must confess I did a short answer :)