Hibernate Community • View topic - HQL with related object

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

HQL with related object

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

mpeter22

Post subject: HQL with related object

Posted: Tue Jun 13, 2006 4:01 am

Newbie

Joined: Tue Apr 11, 2006 4:57 am
Posts: 17

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:
3.1.3

I have a database table called person, and another called name (so the Data Objects have similar structure). In the person dataobject there is a name dataobject.
The name contains name and nickname.
How can I retrive person if I only know the nickname (with HQL) ?

(somethin' like "from Person as person where person.name.nickname = ?) ???

Top

pepelnm

Post subject:

Posted: Tue Jun 13, 2006 4:09 am

Expert

Joined: Thu Sep 22, 2005 10:29 am
Posts: 285
Location: Almassera/Valencia/Spain/EU/Earth/Solar system/Milky Way/Local Group/Virgo Supercluster

You can use this

Code:

from
   Person as person
   inner join person.name as name
where
   name.nickname = :nickname

or this