Hi,
Is it allowed to select multiple kinds of objects in hsql, for example the following hsql:

select usage.product.id usage.cpbr.testSite usage.cpbr.process.name from CPBasicRecordInfo as usage where usage.status = ?

, where there are 3 kinds of objects selected usage.product.id usage.cpbr.testSite usage.cpbr.process.name.

If this is allowed, how to retrieve the returned list?

Regards,
Rice

Queries may return multiple objects and/or properties as an array of type Object[]

select mother, offspr, mate.name
from eg.DomesticCat as mother
inner join mother.mate as mate
left outer join mother.kittens as offspr
or as an actual typesafe Java object

select new Family(mother, mate, offspr)
from eg.DomesticCat as mother
join mother.mate as mate
left join mother.kittens as offspr
assuming that the class Family has an appropriate constructor.



http://www.hibernate.org/hib_docs/refer ... hql-select