count(1) raising an error unexpected token: 1

[aravind yarram]

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

[Mark Spritzler]

Yeah, just change it to an attribute of Csa.

Mark