Hibernate Community • View topic - How to specify GROUP BY ... HAVING using Criteria API ?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to specify GROUP BY ... HAVING using Criteria API ?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

Setya

Post subject: How to specify GROUP BY ... HAVING using Criteria API ?

Posted: Mon Aug 22, 2005 2:16 am

Beginner

Joined: Wed Aug 25, 2004 10:27 pm
Posts: 21
Location: Indonesia

Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version: 3.0.5

Name and version of the database you are using: SQL Server 7.0

Hi all,

I need to translate the following query into Criteria API :

SELECT COUNT(OrderId) FROM OrderDetails GROUP BY OrderId HAVING COUNT(OrderId) > 1.

So far I come up with the following routine :

Code:

Criteria criteria = session.createCriteria(OrderDetail.class);
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.count("orderId"));
projectionList.add(Projections.groupProperty("orderId"));
criteria.setProjection(projectionList);

But I have no idea how to specify the HAVING clause.

Any help would be greatly appreciated.

Regards,

Setya

Top

pearl8

Post subject:

Posted: Mon Aug 22, 2005 2:24 am

Newbie

Joined: Tue Aug 16, 2005 8:28 am
Posts: 15

Hi Setya,

Please look at

http://www.hibernate.org/hib_docs/refer ... ryhql.html

If this answers your question, please give me credit.

Top

sergeya

Post subject:

Posted: Mon Aug 22, 2005 5:18 am

Regular

Joined: Thu Dec 02, 2004 7:11 am
Posts: 85

Criteria API doesn't support HAVING clause yet. See also this topic.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum