PROBLEM WITH AGGREGATE FUNCTION RETRIEVAL

nathan · **Posted:** Tue Oct 28, 2003 8:58 am

hi,
I'am a starter in the hibernate arena.
Please help in the following problem.
I'am facing a problem while using aggregate functions.
I'am using the example that is given in the documentation.

Query q = session.createQuery(
"select blog.name,count(blog) from eg.Blog as blog group by blog.name");

List l=q.list();
String b=(String)l.get(0);
System.out.println("count"+b);

here I'am facing a serious problem .
I'am getting class cast exception in this case.
I cannot cast the the object in the list to String or Integer.
What to do?

christian · **Posted:** Tue Oct 28, 2003 9:00 am

What is returned is not a String, but an Object[], index 0 is a String, index 1 is an Integer.

nathan · **Posted:** Tue Oct 28, 2003 9:08 am

[quote="christian"]What is returned is not a String, but an Object[], index 0 is a String, index 1 is an Integer.[/quote]

It's not accepting an Object Array it's returning an object

christian · **Posted:** Tue Oct 28, 2003 9:15 am

I'm sure it doesn't, it's an Object[].