Hibernate Community • View topic - Getting result count with Criteria API

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Getting result count with Criteria API

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

rfkrocktk

Post subject: Getting result count with Criteria API

Posted: Tue Jul 07, 2009 1:16 pm

Beginner

Joined: Mon Jul 07, 2008 8:07 pm
Posts: 42

Is there a way to get a count of the number of results that would be returned by the Criteria API?

Eg:

Code:

session.createCriteria(User.class).add(Restrictions.ge("years", 5).count()

Top

Sounie

Post subject: Re: Getting result count with Criteria API

Posted: Tue Jul 07, 2009 3:38 pm

Regular

Joined: Fri Jan 30, 2009 10:10 am
Posts: 74
Location: London

Hi,

Have you looked into Projections?

Perhaps something like:

session.createCriteria(User.class).add(Restrictions.ge("years", 5).setProjection(Projections.rowCount());

--
Stephen Souness

blog: http://elegant-solutions.blogsot.com/

Top

rfkrocktk

Post subject: Re: Getting result count with Criteria API

Posted: Tue Jul 07, 2009 4:02 pm

Beginner

Joined: Mon Jul 07, 2008 8:07 pm
Posts: 42

I think this is exactly what I'm looking for. Thanks!

Top

rafaleco

Post subject: Re: Getting result count with Criteria API

Posted: Tue May 25, 2010 5:25 pm

Newbie

Joined: Tue May 25, 2010 5:16 pm
Posts: 3

And when we have a Join table in select?
How do to get a Projection.rowCount() ??

The Hibernate ignores the join.

tks

Top

Page 1 of 1

[ 4 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