Query to get special results, not a mapped class...

ernani · **Posted:** Thu Feb 19, 2004 6:48 am

Hi, using hibernate 2.1.2.

I am doing a simple query like this:

select a.code, b.description, c.min(students), c.max(students)
from com.here.beans.BeanC c,
inner join c.description_table b, c.codes a
group by a.code, b.description

the results of this query is not a persister class....so I don't know hou I can get this values, when I try to execute it from hibernate IDE it works really fine, but within java id warns me this:

no persistent classes found for query class: select a.code, b.description, c.min(students), c.max(students) ...

Again, this query works on Hibernate IDE, but how to get this values within java class?

michael · **Posted:** Thu Feb 19, 2004 6:49 am

Code:

List result = session.find("select a.code, b.description, c.min(students), c.max(students)
from com.here.beans.BeanC c,
inner join c.description_table b, c.codes a
group by a.code, b.description ");
Object[] row = result.get(0);
String acode = row[0];

ernani · **Posted:** Thu Feb 19, 2004 6:53 am

Thanks Michael...

It really works fine here...