[ i am using hibernate 3.2]

When my query looks like this

<query name="getCountGroupByName">
select count(group)
from ClusterGroupDO group
where group.name=?
</query>

I see hibernate error
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: group near line 2, column 22

But when I replace "group" above by "g", it works fine

<query name="getCountGroupByName">
select count(g)
from ClusterGroupDO g
where g.name=?
</query>

What is the explaination?

Maybe group is a reserved word since it is also used in group by.

> Maybe group is a reserved word since it is also used in group by.

I think you are right. However, another very similar query (except it does not count) works fine using "group".

<query name="getGroupsByName">
from ClusterGroupDO group
where group.name=?
</query>