How can I query the object that has primary key class

avseq · **Joined:** Tue Aug 29, 2006 2:54 am **Posts:** 16

I have two class, Persion.java and PersonPK.java

http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html
According to this document, I can query the object like
from Person where person.id.country = 'AU' and person.id.medicareNumber = 123456

But it occur exception,
org.hibernate.hql.ast.QuerySyntaxError: Invalid path: 'person.id.country'
Is there someting wroing with the query?

gskempes · **Joined:** Mon Nov 22, 2004 11:21 am **Posts:** 42

I think the alias "person" is missing in your query, so please try either:

Code:

from Person person where person.id.country = 'AU' and person.id.medicareNumber = 123456

or:

Code:

from Person where id.country = 'AU' and id.medicareNumber = 123456

Regards,
Georg

P.S.: Please rate this posting if it helps solving the problem.