[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6152) retrieve problem when using <join table clause
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira