Hi,
It sounds like a very basic and simple need,

is it possible to count rows from hibernate query without calling the list?

If not, is there a efficiency cost for calling this list for this purpose? (Otherwise I would call it only after adding pagination).

You could use a query:
Or use Criteria:

This will make a list but it only contains the count.

Of course I can do that,
but I asked about HQL and the ability to count HQL query result rows.

Solutions such as building additional query with select(*) are not pretty, solutions that suggest manipulating the hql query string manually are also very risky.

The solution I would have done in proper SQL would be:



But I don't think it is an option here since I'm not sure I can get the query parameters, or clone a query, and also this syntax doesn't seem to be supported by HQL.

Thanks,
Roee.

I believe this is HQL (could be mistaken):
If it was native SQL I would need to use session.createSQLQuery()

Sorry,
but this is not what I asked.
I want to get as parameter HQL query for example (Select * from a where a.b=c.d.....)
and return the count of rows it would return.

I'm sorry but I really don't understand what it is you want.

Perhaps you could rephrase your question, or maby somone else understands it.