I have a mapping many to one fairly standard I think a "titles" class with a genre property which is an instance of a genre class

<many-to-one name="genre" class="my.domain.Genres" column="genreid"/>

I can do this HQL successfully:
"select titles.genre.genreid from Titles as titles"

BUT

I am using the criteria api to build dynamic queries, and when I attempt to add
crit.add(Expression.eq("genre.genreid", x));

I get an exception:
net.sf.hibernate.QueryException: unresolved property: genre.genreid [null]

any advice?

thank you,
Al

crit.createCriteria("genre").add(Expression.eq("genreid", x));

Hibernate 2.1.

Thank you

OK, but I want to create a criteria based on two classes now
i.e where titleName=x and genreid=y
(Titles->titleName, Genre->genreid)

if I have to create two criteria, how can I "and" the two together, because I only way that I can see is to do
Criteria crit1 = ses.createCriteria(Titles.class);
crit.add...
crit.list();
Criteria crit2 = ses.createCriteria(Genre.class);
crit.add...
crit.list();

Can I feed the results of one list into the second criteria?

cheers, al

You misunderstood. It helps to read the documentation.

There are two methods named createCriteria(), one on the Session intfc, one on the Criteria intfc. Ther have completely diff signatures.