Simple select

bluedog73 · **Joined:** Sun Nov 26, 2006 12:53 pm **Posts:** 13

Hello everyone,
i have a class User that contains a field person,
i want to select all the users with person.name = John.

The mapping for User (old style xml for old project) is smth like this:

Code:

<class name="User" table="user"> 
   <id name="uid" column="uid"> 
      <generator class="increment"/> 
   </id>
   <property name="username"  />
   <many-to-one name="person" class="Person" />
   <property name="deleted" />
</class>

and Person is smth like this:

Code:

<class name="Person" table="person"> 
   <id name="uid" column="uid"> 
      <generator class="increment"/>
   </id>
   <property name="name"/>
   <property name="deleted" />
</class>

could u help me? I know it's easy but I cant remember anything, lol

Cameron McKenzie · **Posted:** Wed Aug 19, 2009 10:01 pm

I'd do a criteria query, although, I always do criteria queries.

Just set up a restriction for the name.person or whatever the dot separated value of the field you are looking for is. That should do it pretty easily.

You might find this tutorial on the Hibernate Criteria API helpful:

http://jpa.ezhibernate.com/Javacode/lea ... riteriaapi