Criteria for complex object

guy · **Joined:** Fri Sep 15, 2006 6:07 am **Posts:** 5

Hi,
I have the following classes, the mapping with hibernate works fine but when i try to fetch by criteria as follows:

Code:

Criteria criteria = session.createCriteria(Alarm.class);

criteria.add(Expression.eq("alarmDetails.status.id", 1L));

I get the following error: org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: alarmDetails.status.id of: Alarm; nested exception is org.hibernate.QueryException: could not resolve property: alarmDetails.status.id of:

Code:

public class Alarm
{
    private AlarmDetails alarmDetails;

    public AlarmDetails getAlarmDetails()
    {
        return alarmDetails;
    }

    public void setAlarmDetails(AlarmDetails alarmDetails)
    {
        this.alarmDetails = alarmDetails;
    }
}


public class AlarmDetails
{
    private Status status;

    public Status getStatus()
    {
        return status;
    }

    public void setStatus(Status status)
    {
        this.status = status;
    }
}


public class Status
{
    private long id;

    public long getId()
    {
        return id;
    }

    public void setId(long id)
    {
        this.id = id;
    }
}

when i create the following criteria:

Code:

Criteria criteria = session.createCriteria(Alarm.class);

criteria.add(Expression.eq("alarmDetails.status.id", 1L));

I get: org.springframework.orm.hibernate3.HibernateQueryException: could not resolve property: alarmDetails.status.id of: Alarm; nested exception is org.hibernate.QueryException: could not resolve property: alarmDetails.status.id of:

CWitherow · **Posted:** Wed Nov 08, 2006 11:35 am

I've seen confusion when attempting to use nested properties with Criteria so try

Code:

Criteria criteria = session.createCriteria(Alarm.class);
criteria.addAlias("alarmDetails", "ad"); 
criteria.addAlias("ad.status", "s");
criteria.add(Expression.eq("s.id", 1L));

I'm assuming your mapping files mirror the POJO classes but you should check them.

Curtis ...

guy · **Joined:** Fri Sep 15, 2006 6:07 am **Posts:** 5

Hi Curtis
Tnx for the fast replay. your suggestion works fine.

Guy