Hi,

I want to fetch 2 classes that have no directly mapped relation. I want to get them as Object[], where object[0] is the first class, and object[1] is a collection of all elements of the second class.

Imagine that I have a Poll that has several Questions. Each Visitor can give an Answer to every Question in a Poll. Now I want something like this:

select visitor, answer from Visitor visitor, Answer answer .....

The problem here is that I get a result for every answer of every visitor. Instead I want only individual Visitors and all answers grouped together in a Collection.

Does anybody know if this is possible and if so, how to do this?

Regards, Jeroen

Hibernate HQL does not support arbitrary joins, you need to use native SQL support to do what you want
http://www.hibernate.org/hib_docs/v3/re ... rysql.html