Hi,

I'm new to the Criteria API and I'm trying to write an ad-hoc query generator but failing to find the solution to a particular problem. Got to the stage where I'm not sure if it's my knowledge lacking, or it just can't be done.

I'm after instances of class x. I have two limiting criteria, say;
x.a.b.c.d = ?
x.y.z = ?

What I would like to do is combine the results of these two criteria in a logical manner (eg, d = ? AND z = ?), but I can't seem to find a way of using the api to do both the logical combining and ensuring the joins underlying the associations (x.a.b.c and x.y) are used (as implict are not supported in Criteria). I've tryed both chained createCriteria and using aliases but haven't had any success.

Before I go and implement the logical combinations in java, is there anyway I can do this directly using the Criteria API.

thanks in advance,

Jonny

Have a look at the javadocs for Expression.conjunction() and Expression.disjunction().

Then have a look at the Hibernate chapter posting at http://www.theserverside.com - an example is illustrated using these methods.

Thanks for the reply.

I found the chapter after I posted the message and it gave me enough examples to solve the problem. Using aliases was the key.

Can't wait to buy the book.