Criteria query and components (value types)

bbb321 · **Joined:** Mon Aug 23, 2004 7:54 am **Posts:** 15

Hello

I have the following mapping:

Code:

<class name="User" table="USER">
     ...
     <one-to-one name="person" class="Person"/>
</class>

<class name="Person" table="PERSON">
      ...
      <component name="address" class="Address">
           ...
           <property name="city" type="string" column="CITY"/>
      </component>
</class>

I try to build a Criteria query knowing the city:

Code:

DetachedCriteria detachedCriteria = DetachedCriteria
         .forClass(User.class)                  
         .createAlias("person", "p")
         .createAlias("p.address", "a")
                        .add(Restrictions.like("a.city", myCity);

The error I get is:
could not resolve property: address of: Person

What am I doing wrong?

bbb321 · **Joined:** Mon Aug 23, 2004 7:54 am **Posts:** 15

Very stupid question I guess... createAlias it's about joins and I have components here.
I should have done Restrictions.like("p.address.city", myCity)
and eliminate createAlias("p.address", "a").

Cameron McKenzie · **Posted:** Mon Jun 23, 2008 10:11 am

Restrictions is definitely the way to go.

Don't feel bad about stupid questions. There's probably thousands of very smart people out there asking themselves the very same thing!

By the way, here's a very simple and straight forward tutorial on how to use the Hibernate Criteria API:

http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=09howtousethecriteriaapi

You might find it helpful.