Hello All,
It looks very simple problem but I am not able to figure it out :(

If I execute List crit = session.createCriteria(LottoResult.class).add (Restrictions.eq("lotto.price", new Integer(11))).list(); ; it gives me following exception :
org.hibernate.QueryException: could not resolve property: lotto.price of: com.lottos.domain.LottoResult
at org.hibernate.persister.entity.AbstractPropertyMapping.propertyException(AbstractPropertyMapping.java:44)

mapping and source code is below:
<hibernate-mapping>
<class name="com.lottos.domain.Lotto" table="lotto">
<id name="id">
<generator class="native"/>
</id>
<property name="price" not-null="true"/>
</class>
</hibernate-mapping>

<hibernate-mapping>
<class name="com.lottos.domain.LottoResult" table="lottoResult">
<id name="id">
<generator class="native"/>
</id>
<many-to-one name="lotto" class="com.lottos.domain.Lotto"
column="lottoId" not-null="true"
fetch="select" lazy="false"/>
</class>
</hibernate-mapping>


public class Lotto {
int id;
int price;
public int getPrice() {
return price;
}

private void setPrice(int price) {
this.price = price;
}

int price;
.....
}


public class LottoResult {
Lotto lotto;
public Lotto getLotto() {
return lotto;
}

public void setLotto(Lotto lotto) {
this.lotto = lotto;
}
}

Help is highly appreciated.

Try this:



Creating the alias on "lotto" will set up the join between the tables (which seems like what you need here). The default type of join is INNER JOIN, but you can add an optional 3rd parameter to createAlias to specify a Full or Left Outer join as well.

Thanks a lot it worked. Still i am not sure why I have to explicitly create Alias; in the mapping file I have already specified foreign key relationships..

Anyway thanks for ur help.. it works and thats what matters :)