Hibernate Community • View topic - Get row count using Criteria

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Get row count using Criteria

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

SIau_Tie

Post subject: Get row count using Criteria

Posted: Mon Aug 20, 2012 10:00 am

Senior

Joined: Wed Sep 19, 2007 9:31 pm
Posts: 191
Location: Khuntien (Indonesia)

Hi All,

Let's say I have Criteria like this:

Code:

DetachedCriteria dc = buildCriteria();
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.property("username"), "username");
projectionList.add(Projections.count("record"), "totalRecord");
projectionList.add(Projections.groupProperty("username"));
dc.setProjection(projectionList);
....
//c.setFirstResult(10);
//c.setMaxResults(20);

I would like to get total of the record returned by this criteria?

Thanks

Top

Page 1 of 1

[ 1 post ]

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