Hi all

I have a model structure like this:

Companies whose have many managers whose have many benefits

benefits has a name and a value (eg 'laptop' as name and 'acer' as value)

I would like to make a criteria query to know which companies has managers with 'acer'- 'laptop' and 'ericson' - 'cellphone'

simple adding Criterion to a Criteria like this

Criteria c = session.createCriteria(Company.class).createCriteria("managers").createCriteria("benefits");

give no results since hibernate tryies to find a benefit that has name 'laptop' and 'cellphone'

I tried using disjunction to agregate criterions before adding them to the criteria but hibernate gave me back all the companies that has a manager with at least one of the benefits

Sadly all the maping file and the properties are in italian and are almost unreadable... but they work great for the all aplication...


thanks folks!

Sammy


Hibernate version: 3


[/b]