Hi All

I am new to Hibernate.

I am using Hibernate3.jar & Oracle9i database.

This is the query i have which i need to run using Hibernate
****************************************
select a.id ,a.number ,ag.name ,s.title
,gp.ptitle ,(select sum(nvl(rs.amount,0))
from rights ,rights_ext
where rights.id (+)= a.id
and rights.rights_ext_id (+)= right_ext.ser_id) amount
,a.status_id, p.name
from a , ap ,gp ,sa ,s ,ag ,apr, p
where a.id = sa.id
and sa.serid = s.serid
and a.id = ap.id
and ap.pid = gp.pid
and a.statusid <> 1
and a.classid = 3
and astatusid = ag.lkid
and a.id = ap.id
and ap.roleid = 1
and ap.pid = p.pid
****************************************

I want to use createSQLQuery of Hibernate & run this query & not HQL.
I want to know how will i capture this return type which is basically columns from different tables.

I cannot use a single domain object (class which maps to a table) in this scenario.
I get a return type as List. Now how do I retrieve the indvidual column values from this List.

Kindly if possible illustrate with a sample case

Regards

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



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