users@jpa-spec.java.net

[jpa-spec users] Row count for criteria query

From: <etaizzz_at_gmail.com>
Date: Sun, 2 Dec 2012 15:24:01 +0000 (GMT)

Hi,
I know I'm a little bit late to the game but unfortunately I only
caught wind of this great effort two days ago.
I hope there is still room for some small changes and additions.
I've searched the mailing list and could not find any reference to
having access to the row count a query generated.
This metadata is crucial when performing pagination against a large
resultset.
The current workaround is usually implemented as two db queries- one
for the data and one for the count.

It seems to me that this metadata can reside on the Query interface as
a getter.

I'd really appreciate feedback on this issue.

BTW, if I should have posted to the issues mailing list please update
me and I'll post to there from now on.

Two stackoverflow questions on the same subject:
http://stackoverflow.com/questions/5349264/total-row-count-for-paginati
on-using-jpa-criteria-api

http://stackoverflow.com/questions/3997587/jpa-2-0-count-for-arbitrary-
criteriaquery