I try use criteria to search with component field. example

class House
public class House {

private int id;

private String ower;

private Adress adress;

getter....
setter.....
}
class Adress
public class Adress{
private String street;
private String city;
}

My House table
SCM_HOUSE
ID int
OWER varchar2(50)
STREET varchar2(50)
CITY varchar2(30)


House.hbm.xml
<hibernate-mapping>
<class name="com.scm.model.House" table="SCM_HOUSE" schema="SCM">
<id name="id" type="long">
<column name="ID_HOUSE" precision="22" scale="0" />
<generator class="increment"/>
</id>

<component name="adress" class="com.scm.model.Adress">
<property name="street">
<column name="STREET />
</property>
<property name="city">
<column name="CITY" />
</property>
</component>

<property name="ower">
<column name="OWER" />
</property>
</class>
</hibernate-mapping>

when I try do this:

session = getHibernateTemplate().getSessionFactory().openSession();
Criteria criteria = session.createCriteria(clazz);
criteria.add(Expression.eq("ower", "paul"));

Criteria criteriaAdress = criteria.createCriteria("adress");
criteriaAdress.add(Expression.eq("city", "alabama"));
Collection result = criteria.list();

I get this error: could not resolve property: city of: com.scm.modelo.House.
but if I am not use component field, if a use a
relationship one to one or some other, I get sucess in my operation.so this problem occurs only if I use a component field (agregate) in my class.

some body knows how can I resolve this problem???


Report this post

pleaseeeeeeeee help me

I haven't use this, but what I think you are doing wrong is, that Adress is not mapped, it is just a component.

Maybe, it should be something like this?

criteria.add(Expression.eq("adress.city", "alabama"));

Collection result = criteria.list();