Hi,

We are using Hibernate 3.1.x. I am trying to get a list of properties instead of a collection using Criteria. When I run the form I have, no sql gets executed and there are no errors. can someone help me figure out the criteria or let me know whether it is possible or not.

DetachedCriteria criteria;
long parentId = 5;

//create the criteria for the list of properties
criteria = DetachedCriteria.forClass(Children.class)
.setProjection(Projections.property("name"))
//create the sub criteria
.createCriteria("parent")
//add the parent id restriction to the sub-criteria (Parent)
.add(Restrictions.eq("parentId", parentId));

Here is my current criteria. I am trying to get a list of names stored in the child collection by passing in the parent id. Parent -> Children is a one-to-many relationship. For simplicity (not real code), here is the simple classes

public class Parent {
public long parentId;
public Set children;
}

public Children {
public Parent parent;
public String name;
}

Thanks for any help in advance.

You're doing it backwards. Try this:

Thanks, that worked.