About Jub-Class For Hql

ice wang · **Posted:** Wed Oct 19, 2005 12:43 am

Hi,
I can only get Base object(parent),
but I want to underside condition HQL and get dataBase Data,
What do I have to do?

Code:

   SELECT  
        p
   FROM 
        //parent class
        Parent p 
   WHERE 
        //sub class condition 
         P.childName="Test" OR p.Email="test@ww.com"

Code:

hbm.xml:

          <.........>
          <class name="parent">
                <joined-subclass name="child1">
                      <Property name="childName"/>
                </joined-subclass>

                <joined-subclass name="child2">
                      <Property name="Email"/>
                </joined-subclass>
          </class>

<...........>

KPixel · **Posted:** Wed Oct 19, 2005 9:45 am

AFAIK, you need to run one query for each sub-class if you want to use their properties in the where clause.