Hibernate criteria in many-to-one mapping.

[harshad kadam]

I am using criteria to select some records from DB with restrictions on it. I have one table say A & its pojo A.java, its field mapped with other table B. (many-to-one).
When i use criteria with restriction, the id (which is the primary key of ) of other class is mapped in the property field. But when i give some other variable from B.java, it gives "could not resolve property" excepion.
Why this happens?

here is the code:

session.beginTransaction();
			Criteria criteria = session.createCriteria(LogSheetLog.class);
			if(filters.getFromDate() != null && filters.getToDate() == null)
			{

				criteria.add(Restrictions.ge("dateTime", Util.StringToDate(filters.getFromDate(), "dd-MMM-yyyy")));
			}
			if(filters.getToDate()!=null && filters.getFromDate() == null)
			{
				criteria.add(Restrictions.le("dateTime", Util.StringToDate(filters.getToDate(), "dd-MMM-yyyy")));
			}
			if(filters.getToDate()!=null && filters.getFromDate() != null)
			{
				criteria.add(Restrictions.between("dateTime", Util.StringToDate(filters.getFromDate(), "dd-MMM-yyyy"), Util.StringToDate(filters.getToDate(), "dd-MMM-yyyy")));
			}
			if(filters.getAttendedBy()!=null)
			{
				criteria.add(Restrictions.like("updatedUserId.officerName", filters.getAttendedBy(), MatchMode.ANYWHERE));
			}
			if(filters.getStatus()!=null)
			{
				criteria.add(Restrictions.eq("logSheet.status", filters.getStatus()));
			}
			criteria.addOrder(Order.desc("dateTime"));
			dailyWorkReport = criteria.list();
			session.getTransaction().commit();

[harshad kadam]

the properties "updatedUserId.officerName" & "logSheet.status" are not being resolved!

[Hemant Thard]

hi harshad ,

try using this :

List cats = sess.createCriteria(Cat.class)
    .createAlias("kittens", "kt")
    .createAlias("mate", "mt")
    .add( Restrictions.eqProperty("kt.name", "mt.name") )
    .list();

[Hemant Thard]

Hi harshad ,

try using alias.

here's an example

List cats = sess.createCriteria(Cat.class)
    .createAlias("kittens", "kt")
    .createAlias("mate", "mt")
    .add( Restrictions.eqProperty("kt.name", "name") )
    .list();

[Hemant Thard]

here's another way

List cats = sess.createCriteria(Cat.class)
    .add( Restrictions.like("name", "F%") )
    .createCriteria("kittens")
        .add( Restrictions.like("name", "F%") )
    .list();