I am upgrading hibernate 3.1.2 to 3.5.4.
In query i used count() function and add addScalar() as Integer. In older ver. i get int value but after upgrading i get long value and throw class cast exception.

code are:

StringBuilder query = new StringBuilder(
"select count(distinct s.student_id) as tot from teacher t inner join student s p on s.student_id=t.student_id");
Query q = getQuery1(query, organization, accessiblePortfolio, true, fetchExportControl, type,
false, filterHelper);
((SQLQuery) q).addScalar("tot", Hibernate.INTEGER);
return (Integer) q.uniqueResult();

Please help me.
Thanks.

try this: