Hello,
I haven't really executed this type of native query yet, but I would expect hibernate to return a list of tuples (see docs 10.4.1 - Executing queries).
Some example code would be
Code:
List items = session.createSQLQuery(...).list();
Iterator itemIt = items.iterator();
while (itemIt.hasNext()) {
Object[] item = Object[]itemIt.next();
Number id = (Number)item[0];
...
String title = (String)item[3];
...
}
But of course this kind of code is very vulnerable to changes in the query. You can always create a custom object that represents the result of this query and define the return values in a mapping file (see docs 16.3 - Named SQL queries).
Hope this helps.
Luc Feys