HQL "select count(*)" returns Long?

asklxf · **Joined:** Fri Feb 17, 2006 12:18 am **Posts:** 11

hi, i'm using hibernate 3.2 RC2, and i found a very strange problem:

when i try to use hql:

"select count(*) from..."

Code:

int count = ((Integer)query.uniqueResult()).intValue;

it report a ClassCastException, and after trace i found the real type returned by "select count(*)" is Long!!!

is it caused by HSQLDialect? For these codes works well in hibernate 3.1.2 and SQLDialect.

thanks![/b]

max · **Posted:** Sat Jul 08, 2006 4:28 pm

if you read the migration guide and change log you would now the answer.

This was needed to be JPA compliant. see the migration guide on our wiki.

asklxf · **Joined:** Fri Feb 17, 2006 12:18 am **Posts:** 11

Thx! and i found out how to make my code works:

Code:

  Configuration classicCfg = new Configuration(); 
  classicCfg.addSqlFunction( "count", new ClassicCountFunction()); 
  classicCfg.addSqlFunction( "avg", new ClassicAvgFunction()); 
  classicCfg.addSqlFunction( "sum", new ClassicSumFunction()); 
  SessionFactory classicSf = classicCfg.buildSessionFactory();

tiagoaugusto · **Joined:** Mon Aug 28, 2006 4:43 pm **Posts:** 6

I tried do

Configuration classicCfg = new Configuration();
classicCfg.addSqlFunction( "count", new ClassicCountFunction());

but the class org.hibernate.cfg.Configuration do not have the method addSqlFunction.

What i wrong?

max · **Posted:** Mon Aug 28, 2006 5:02 pm

you are not using a recent release of hibernate 3.2.x

tiagoaugusto · **Joined:** Mon Aug 28, 2006 4:43 pm **Posts:** 6

But i am using the version 3.2.0-cr2

max · **Posted:** Tue Aug 29, 2006 7:33 am

the latest release is -cr4

tiagoaugusto · **Joined:** Mon Aug 28, 2006 4:43 pm **Posts:** 6

OK, tks for the help. But in the web site the is no link to get cr4, but if you write in the url to get cr2 and jsut change cr2 to cr4 its works. :)

tks once more.

max · **Posted:** Tue Aug 29, 2006 7:41 am

what part of the webpage are you looking at ?

tiagoaugusto · **Joined:** Mon Aug 28, 2006 4:43 pm **Posts:** 6

This page http://hibernate.org/6.html, in the download area.

max · **Posted:** Tue Aug 29, 2006 7:48 am

ah - fixed. thanks.

tiagoaugusto · **Joined:** Mon Aug 28, 2006 4:43 pm **Posts:** 6

Ok :)