In the style of the reference docs, this in HQL doesn't work because "kittens" is a set, or list, or whatever:

select distinct cat
where cat.kittens.age > 10

So that would give me all cats who have a kitten older then 10. Or, in SQL (which does work), if you prefer:

SELECT DISCTINCT m.*
FROM cat c
INNER JOIN kitten k ON k.momID = c.id
WHERE k.age > 10

I've got many JDBC queries that I am DYING to replace to get my app running totally through Hibernate, but they are all in this style. Am I missing something? Thanks!

umm aren't you missing a from clause ;)

Okay, my bad on that one. My example was meant to be:

select distinct cat
from Cat cat
where cat.kittens.age > 10

That still won't work, however. Here's my actual query, just so I can't mess up another example. :D



So healthplan is joined to provider as a many to many. I need to include the join table because it contains other information that I need. Here's what Hibernate has to say:

QueryException: expecting 'elements' or 'indices' after: healthPlan

Okay, I'm sorry, I don't think I have enough understanding of exactly what I'm doing here. I'm going to try mapping the relationship as a many-to-many and try to figure out how to get the fields of the join table that I need (component I think). Anyway, we'll see how this works when I set it up the RIGHT way. :D

Okay, so I did that, which made the design a lot cleaner:



however I still get the same error.

select distinct ep.state
from EzProv ep
inner join ep.healthPlans hp
where hp.hpcode = ...

I *think* is what you are looking for, though without the mappings I am just making wild guesses ;)

Woo hoo, that worked! Thank you so much for your help, Steve. I guess the problem was that I just assumed that actually using the keyword "JOIN" was not ever necessary.