I have been using Hibernate for some time quite happily, but ran into a issue with a new query. I am trying to create a query:

...
select s.name, s.description, count(elements(s.children)), elements(s.favoriteActivities), s.birthday
from Staff s
order by s.name
...

where s.children is a List and s.favoriteActivities is a Map. I am trying to get the query to return an Object[] that will let me access the "elements" of the favorite activites but this does not seem to work. Can anyone help me with this?

I am using Hibernate 2.0.1 with MySQL 4.1.

-- Eric