List list1 = s.createCriteria(Order.class)
.createCriteria("items", "item")
.add( Expression.eq("item.name", "p123") )
.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY)
.setMaxResults(5)




List list2 =
s.createQuery(
"from Order order "
" where exists
( from items as item
where item.order = order
and item.name= :name )
)
.setParameter("name", "p123")
.setMaxResults(5)
.list();

Is there a way to make the first query behave like the second?

yes you can criteria can execute very complexe queries.
But give more details about your question, DB schema, POJO...

Schema is simple Order and Line like in the Hibernate example chapter.


I want all Orders where Item "Milk" was Ordered.
Let us say in Order1 there are 100 items all of them for Milk.
Similarly Order 2.


When executing the exist query I am guaranteed to get only 1 occurance of Order no matter how many items were Milk.

Executing the criteria query I dont get the same results.