How to search two tables?

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Hi everyone:

I want to add a search function to my web application. I use hibernate paging interface . But the hibernate doc show how to search one table using

Code:

setMaxResult(); setFirstResult();

But the problem is that if I want to search two tables what will return ? I means that If I search one table it will return a POJO object,but if two tables? For example: HSQL:

Code:

from Article a Author au where a.title='book' and au.name='yashnoo'

what will return ?

I don't know what object it will return. Please help me.

Myk · **Joined:** Sun Jan 04, 2004 2:46 pm **Posts:** 147

It will return a List containing Object[]. Each Object[], Object[ 0 ] will be the article and Object[ 1 ] the author.

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Thks Myk.

But if I want to paging the result,how to do it? I mean that could hibernate limit the result count if I query several tables?

For example: like this query:

Code:

select g.groupname, r.roleid, u.username from Group g,Role r , User u where g.groupid=1 and r.role_description='good'.

You will find that it is difficult to paging. If I query one table ,I can paging like this:

Code:

Query q=session.createQuery("from Group");
setMaxResult(..); 
setFirstResult(..);

But if more than one tables:

Code:

Query q=session.createQuery("select g.groupname, r.roleid, u.username from Group g,Role r , User u where g.groupid=1 and r.role_description='good'.");
setMaxResult(..); 
setFirstResult(..);

What will return ? If it return a List, what will I get in this List?
Help!

Yashnoo · **Joined:** Wed Dec 17, 2003 4:24 am **Posts:** 188

Any idea?