Hi,

The following HQL is resulting in parsing error at count (1). The problem is at the numeric 1 I am using in the count function. If i use a column name instead of the constant, the query executes successfully. Is this a restriction of hibermate?

select count(1) from Csa c where c.equipment.equipmentType = 'MA'

Thanks for your help!

Hibernate version: 3.x

¿Why are you using a constant instance of the column name? you must use a column name within the count function. the use is exactly the same as SQL COUNT Sintaxys

COUNT(1) gives get better performance as the database engine will not have to fetch back the data fields if column name is used

If you are concerned about performance and not fetching everything while doing a count you can try the following:

You can count the number of query results without actually returning them:


This tip is from here:
http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html

Thanks for the tip,

However i am planning to stick with the count(id) paradigm as using iterate or scroll in the JTA environment forces us to explicily close them due to some hole in the JTA spec!