Criteria search possible on sub-properties?

PhilWilson · **Posted:** Thu Jun 03, 2004 7:19 am

Hi all,

I have three objects A, B and C.

A has a property B and B has a property C and C has a property 'id".

I want to use a Criteria query to perform the equivalent of "select * from A where A.B.C.id = 7"

Is this possible, or even desirable?

Are there better alternatives?

I've spent some time searching the forum but can't find anything similar.

Thanks for any help anyone can give.

PhilWilson · **Posted:** Thu Jun 03, 2004 7:24 am

Oops, I should have mentioned that I'm using Hibernate 2.1 and that these are all 1-1 relationships and that I tried to follow the instructions in http://www.hibernate.org/hib_docs/refer ... sociations but I just couldn't get it right.

christian · **Posted:** Thu Jun 03, 2004 7:35 am

Code:

List result = session.createCriteria(A.class).createCritiera("b").createCriteria("c").add( Expression.eq("id", new Integer(7)) ).list();

You can "nest" criterions.

PhilWilson · **Posted:** Thu Jun 03, 2004 7:44 am

That's brilliant, thanks!

I'd nested B already but it didn't occur to me that I could nest again. Morons of the world - unite!