Hi,

I am trying to get the count using HQL.

This is my code:
Integer id = (Integer)session.createQuery("select count(*) from Orders").uniqueResult();

When i try to cast the return value as Integer i get a ClassCastException
java.lang.ClassCastException: java.lang.Long

It works fine if i cast to a Long. Is there any problem with the code?

Any help is appreciated

Thanks in advance

Um, the count is returned as a Long, you're casting to an Integer. Long != Integer so you get the class cast. I fail to see what the real issue is.

Do you mean to say that the count always returns a Long value ?

From the source I am going to say in HQL yes it should by default always return a long.

STANDARD_AGGREGATE_FUNCTIONS.put( "count", new StandardSQLFunction("count") {
public Type getReturnType(Type columnType, Mapping mapping) {
return Hibernate.LONG;
}
} );

However, it would appear the criteria API would return an Integer. Also, the reference docs seem to imply that it would also be an Integer. However, the code will win and you're ending up with a Long.

Thanks for your response