Query using more than one class?

Mørketid · **Joined:** Thu Nov 23, 2006 11:08 am **Posts:** 14

hei, i just started using hibernate and i wonder, how i may create a query using more than one class? this example

Code:

List cats = session.createCriteria(Cat.class)
     .createCriteria("kittens")
         .add( Restrictions.like("name", "Iz%") )
     .list();
 

for example uses Cat.class, but how can i use Cat.class, Dog.class and Bird.class for example to get a list with results?

thanks in advance :-)

halconGT · **Posted:** Thu Nov 23, 2006 12:36 pm

Hi Morketid, I'm not sure it can be possible with Criteria Interfaz, but it is very simple if you use HQL with "select new yourNewClass(Class1.att, Class1.att2, ....)" approach.

I hope it helps