Hibernate version: 3.0.5

Mapping documents:
<class
name="ShopDTO"
table="GTShop"
dynamic-update="true"
>

<id
name="ID"
type="java.lang.String"
>
<column
name="ID"
/>
<generator class="assigned">

</generator>
</id>

<many-to-one
name="productDTO"
class="ProductMasterDTO"
cascade="none"
outer-join="true"
update="true"
insert="true"
access="property"
column="PRODUCTID"
/>
</class></hibernate-mapping>




I am getting an exception when i try to execute the below code.
Criteri cq = session.createCriteria(ShopDTO.class);
cq.add(Restrictions.eq("productDTO.ID", productCode.toString())); //ID is the PK of product//

cq.add(Restrictions.eq("productDTO.productAbbreviated", productAbbr.toString()));

cq.list();

The above code works if i comment the Restrictions.eq("productDTO.productAbbreviated", ..... part


This is the stack trace
org.hibernate.QueryException: could not resolve property: productDTO.productAbbreviated of: ShopDTO
at org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException(AbstractPropertyMapping.java:43)
at org.hibernate.persister.entity.AbstractPropertyMapping.toColumns(AbstractPropertyMapping.java:63)
at org.hibernate.persister.entity.BasicEntityPropertyMapping.toColumns(BasicEntityPropertyMapping.java:31)
at org.hibernate.persister.entity.BasicEntityPersister.toColumns(BasicEntityPersister.java:1086)
at org.hibernate.loader.criteria.CriteriaQueryTranslator.getColumns(CriteriaQueryTranslator.java:403)
at org.hibernate.loader.criteria.CriteriaQueryTranslator.getColumnsUsingProjection(CriteriaQueryTranslator.java:369)



Is this a Known issue? we can query only on primary key of a mapped property using criteria query?

To acces the property of productDTO you must join it. There're two ways of expression join in the Criteria API:

1. Use method createCriteria() of the Criteria interface:

Criteria cq = session.createCriteria(ShopDTO.class);
Criteria productCriteria = cq.createCriteria("productDTO");
productCriteria.add(Restrictions.eq("productDTO.ID", productCode.toString())); //ID is the PK of product//
productCriteria.add(Restrictions.eq("productDTO.productAbbreviated", productAbbr.toString()));

cq.list();

2. Assign an alias to the joined entity:

session.createCriteria(ShopDTO.class)
.createAlias("productDTO", "productDTO")
.add(Restrictions.eq("productDTO.ID", productCode.toString()))
.add(Restrictions.eq("productDTO.productAbbreviated", productAbbr.toString()))
.list();

ist the mapping productDTO property in the ShopDTO.java and do we need getter and setter for it... right...



<many-to-one
name="productDTO"
class="ProductMasterDTO"
cascade="none"
outer-join="true"
update="true"
insert="true"
access="property"
column="PRODUCTID"
/>