My application builds a Criteria object progammatically. Filters (where ...) are created by one routine, while ordering (sort by ...) by another. It appears that Hibernate does not allow the same association to be referenced more than once. Here is some sample code that recreates the problem:



It fails with "duplicate association path: client".

So... is there any way to work around it? For instance, is there any way to progammatically extract any Criteria objects that have possibly already been created for associations out of the root Criteria object?

Thank you in advance!

Try the following:

Criteria criteria = DB.session().createCriteria(Document.class);
criteria.add(Restrictions.eq("id", 1));
criteria.addOrder(Order.asc("name"));
List list = criteria.list();

Codenasher, thanks for the suggestion, but I must not have made myself clear in my first post. Both "id" and "name" properties belong to a "parent" object mapped as getClient() property. Thus, I have to create a new Criterion for that association.

Okay sorry,

when I don't misunderstand you want to do this:

Criteria criteria = DB.session().createCriteria(Document.class);
criteria.createAlias("client", "client")
criteria.add(Restrictions.eq("client.id", 1));
criteria.addOrder(Order.asc("client.name"));
List list = criteria.list();

Woo-hoo! The alias did the trick! Thanks, Codenascher! You definitely earn a crewdit for this one ;)