HQL Archives - Simon Technology Blog

Hibernate – HQL’With ‘clause in JPQL

From the Hibernate 3.6 documentation:

You may supply extra join conditions using the HQL with keyword. from Cat as cat
left join cat.kittens as kitten
with kitten.bodyWeight> 10.0 Thi

October 12, 2021By Simo Hibernate clause, Hibernate, HQL, JPQL, middleLeave a Comment

Hibernate – Connect multiple tables in HQL

Can anyone help me convert this query to HQL

SELECT
supplierOrderDetails.productID,< br /> supplierOrderDetails.orderQty,
supplierOrderReceiveDetail.qtyArrived
FROM
supplierOrder
INNER JO

October 12, 2021By Simo Hibernate connection, Hibernate, HQL, middle, multiple, tableLeave a Comment

Hibernate – HQL on subclass properties

I have a class A and a class B and a class C. They have different attributes.
How do I do:
aaaa where(a.class = B and a .specific-property-of-b = “y”) or (a.class = C and a.specific-property-of-c

October 12, 2021By Simo Hibernate Hibernate, HQL, Properties, subclassesLeave a Comment