[hibernate-issues] [Hibernate-JIRA] Created: (HHH-3792) Entity Inheritance & abstract Field problem
Entity Inheritance & abstract Field problem
-------------------------------------------
Key: HHH-3792
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3792
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.3.1
Environment: JDK6, MySQL
Reporter: Miroslav Nachev
I have one common class CustomerDiscountItem with 2 abstract methods:
@Entity
@Table(name = "customer_discount_items")//, catalog = "acacia_test",
schema = "public")
@Inheritance(strategy=InheritanceType.JOINED)
@DiscriminatorColumn(discriminatorType=DiscriminatorType.STRING, length=2,
name="discriminator_id")
@NamedQueries({
@NamedQuery(
name = "CustomerDiscountItem.findByCustomerDiscount",
query = "SELECT t FROM CustomerDiscountItem t where t.customerDiscount =
:customerDiscount")
})
public abstract class CustomerDiscountItem implements Serializable {
@JoinColumn(name = "customer_discount_id", referencedColumnName =
"customer_discount_id", nullable = false)
@ManyToOne(optional = false)
public abstract CustomerDiscount getCustomerDiscount();
public abstract void setCustomerDiscount(CustomerDiscount customerDiscount);
This class is common for another 2 classes:
public class CustomerDiscountItemByCategory extends CustomerDiscountItem implements
Serializable {
public class CustomerDiscountItemByProduct extends CustomerDiscountItem implements
Serializable {
When I use named query "CustomerDiscountItem.findByCustomerDiscount" the result
is not correct because in where clause only the first class is included:
where cdi_by_category.customer_discount_id=?
The correct where clause should be:
where cdi_by_category.customer_discount_id=? or cdi_by_product.customer_discount_id=?
The whole select statement generated by Hibernate is:
select
cdi.customer_discount_item_id,
cdi.discount_percent,
cdi.discriminator_id,
cdi_by_category.category_id,
cdi_by_category.customer_discount_id as category_cd_id,
cdi_by_category.include_heirs,
cdi_by_product.customer_discount_id as product_cd_id,
cdi_by_product.product_id,
case
when cdi_by_category.customer_discount_item_id is not null then 1
when cdi_by_product.customer_discount_item_id is not null then 2
when cdi.customer_discount_item_id is not null then 0
end as clazz_
from customer_discount_items cdi
left outer join customer_discount_items_by_categories cdi_by_category
on cdi.customer_discount_item_id=cdi_by_category.customer_discount_item_id
left outer join customer_discount_items_by_products cdi_by_product
on cdi.customer_discount_item_id=cdi_by_product.customer_discount_item_id
where cdi_by_category.customer_discount_id=?
--
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