Hi, im new to Hibernate and im trying to get this results.

String sql = "select count(c.id), c.id from Rooms c group by c.id "

List results = getHibernateTemplate().find( sql );

if( results.size() > 0 ) {
AnObject o = list.get(0);
}

where AnObject has the members: Integer count , Long id

but it gets me a Cast Error.
Object can not be cast to AnObject.

Thanks in advance, for your help.

in your case, result of list.get(0) is type Object[]. so you can't cast it to AnObject. you can only cast it to Object[].

But if you have a construtor like this in your AnObject:

AnObject(Integer count, Long cid)
{
this. id =cid;
this.count=count;
}

you can modify your query as below and cast it to AnObject

String sql = "select new AnObject(count(c.id), c.id ) from Rooms c group by c.id "

bytheway, what you are executing is not sql, it is hql.