Hibernate Code for Query

Question

I found this Hibernate Criteria/Projection tutorial clear, concise and informative.

The author, A.P.Rajshekhar, says,

SELECT COUNT(ID) FROM ORDER  HAVING PRICETOTAL>2000 GROUP BY ID

Can be rewritten in Criteria query as follows:

List orders = session.createCriteria(Order.class)
     .setProjection( Projections.projectionList()
      .add( Projections.count(“id”) )
       .add( Projections.groupProperty(“id”) )
     )
      .list();

However, where does the HAVING PRICETOTAL>2000 show up in the Hibernate code? Is there a missing criterion (where clause in SQL) for this comparison?

ndtreviv · Accepted Answer · 2012-12-21 14:13:19Z

5

Yes. You also need:

.add(Restrictions.gt("priceTotal", 2000))

assuming the name of the PRICETOTAL property on the Order class is indeed "priceTotal"

answered Dec 21, 2012 at 14:13

ndtreviv

3,6541 gold badge38 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Hibernate Code for Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related