Hello everyone!

The following Hibernate problem keeps me bugging for ages.

The query itself is quite simple.

The objects are:

Clip and License.

Clip has the following method:

@ManyToMany
public Set<License> getLicenses() {
return licenses;
}


Now I want to query all clips with a specific license:

I have tried:

clipCriteria = clipCriteria.createCriteria("licenses").
createCriteria("license").add(Restrictions.eq("id", getSelectedLicense().getId()));

which returns:

could not resolve property: license of: com.company.dao.License

I have also tried:

clipCriteria = clipCriteria.createCriteria("licenses").add(Expression.eq("id", getSelectedLicense().getId()));

and:

clipCriteria = clipCriteria.createCriteria("licenses")
.createAlias("license","licenses")
.add(Restrictions.eq("license.id",getSelectedLicense().getId()));

and:

clipCriteria = clipCriteria.createCriteria("licenses")
.createAlias("licenses","license")
.add(Restrictions.eq("license.id",getSelectedLicense().getId()));

Has anyone got the right solution?

Thanks!

Toby

Or is this a Hibernate bug ?

The documentation on:

http://www.hibernate.org/hib_docs/reference/en/html/querycriteria.html

does not seem to have an appropriate example....as the Kittens are not a Set of Cats ?