According to the website, I'm supposed to post here for bugs first. So be it.

So here goes. Using the following JPA 2.0 Query constructor, I want to do the equivalent to:

"select count(u) from User u;"

I've confirmed with Linda, the JPA 2.0 spec person at Sun that the code for that should look like this:

public void CountUsers(EntityManager em)
{

CriteriaBuilder cb= em.getCriteriaBuilder();
CriteriaQuery<Long> cq = cb.createQuery(Long.class);
Root<User> u = cq.from(User.class);
cq.select(cb.count(u));
}

Internally, Hibernate generates this string
select count() from com.example.User as generatedAlias0
but then kvetches about the ) as an org.hibernate.hql.ast.QuerySyntaxException.

Pierce

When experimenting with Hibernate 3.5 and JPA 2.0, I hit exactly the same problem: hibernate builds "select count() ...." query and then fails on it. Have you found any workarounds for this, or should we just sit and wait for next hibernate 3.5 version release?

3.5.0-SNAPSHOT fixes it.

We've just plugged in Hibernate 3.5 Beta 4. Looks like exactly the same error happens... Did you have better luck with it?

I have the same problem after releasing the final version Hibernate 3.5.0.
Can anybody help and give the solution?

This must somehow be related to the User class or SQL dialect -- I tried this on 3.5.1 with HSQL and it worked just fine.

Could you post a short example which demonstrates the error?