I have two objects A and B. A looks like

@Entity
@Table(name="TABLE_A")
public class A {
@Id
@Column(name="ID")
private Long id;

@OneToMany(mappedBy="owner", cascade=CascadeType.ALL,
fetch=FetchType.EAGER)
private List<B> listOfBs;
}
B looks like

@Entity
@Table(name="TABLE_B")
public class B{
@Id
@Column(name="ID")
private Long id;

@Column
private double value;

@Column
private Date theDate;
}

Basically I'm trying to compare the B.value of the most recent entry of B (i.e. max(B.theDate)) using a DetachedCriteria object. My attempt is as follows, but its not working. Any help would be appreciated.

DetachedCriteria dc = DetachedCriteria.forClass(A.class);
DetachedCriteria cdc = dc.createCriteria(listOfBs);
cdc.add(Restrictions.eq("value", 5.0));
DetachedCriteria maxDate = DetachedCriteria.forClass(B.class);
cdc.add(Property.forName("theDate").eq(maxDate.setProjection(Property.forName("theDate").max()));

Try this code