[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6152) retrieve problem when using <join table clause

[Sathya Balakrishnan (JIRA)]

retrieve problem when using <join table clause
----------------------------------------------

                 Key: HHH-6152
                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6152
             Project: Hibernate Core
          Issue Type: Bug
          Components: query-criteria, query-hql
    Affects Versions: 3.2.7
         Environment: Hibernate 3.2.7, Oracle 10g database
            Reporter: Sathya Balakrishnan


I have inheritance relation modeled. 
class SuperClass 
   name
   type
   Order order;

class SubClass extends SuperClass
    attr1
    attr2
    etc
in the mapping. I have mapped SubClass in SubClass.hbm.xml and used <join table
   <join table="Super_CLASS">
         <key  column="ID" />
         <many-to-one name="order" class="MyOrder" />

SubClass further has SubSubClass1 SubSubClass2 and modeled using subclass and discriminators. My database model is
there is one SUPER_CLASS table and many SUB_CLASS tables and within one branch of hierarchy there can be many child classes.

Another main class - Order class which contains all the subclasses.

MyOrder
  List<SubClass> subClassList

  mapping is done with bag 
   <bag name="subClassList" table="SUB_CLASS" inverse="true" cascade="all">
      <key column="order_id"
     <one-to-many class="SubClass" />
    </bag>


Now the problem is while retrieving when we traverse the class MyOrder and call getSubClassList() hibernate fires a query to pull this entity but the query generated is using the order_id to query this entity which is correct but
the query generated expects the order_id to be present in SubClass tables alias instead of SuperClass table alias.

for eg : generate query-  select subclass_1.order_id, subclass_1.attr1, subclass_1.attr2, superclass_1.name, superclass_2.type ...
from SUB_CLASS subclass_1 INNER JOIN SUPER_CLASS superclass_1
       ON subclass_1.id = superclass_1.id
 WHERE subclass_1.order_id = ?

order_id field is expected to be found in subclass_1 ( SUB_CLASS ) - This is causing the failure.

How to over come this ?.

Thanks,
Sathya.









 







-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira