HQL Error in Named Query

Question

I'm getting Hibernate's message that I have an "Error in named query".

Below is the HQL statement I'm trying to execute.

select sum(subtotal)
from (
      select sum(coalesce(sum(t2.amount), 0) - coalesce(sum(t3.amount), 0)) subtotal
      from submission t1
      left join t1.bills t2
      left join t1.payments t3
      where t1.id = 10
      group by t1.id

      union

      select sum(coalesce(sum(t2.amount), 0) - coalesce(sum(t3.amount), 0)) subtotal
      from submission t1
      left join t1.otherBills t2
      left join t1.payments t3
      where t1.id = 10
      group by t1.id
) a1

I think the problem might be related to the sum function in the outer query or the union operator but I haven't been able to narrow it down.

Does anyone have any ideas?

score 3 · Accepted Answer · answered Jul 03 '15 at 04:42

3

You can't use a subquery after From clause in HQL. My suggestion is that you can use native query. For more detail you should look at following link :- Hibernate Query Limitation

answered Jul 03 '15 at 04:42

Anirudh Jadhav

967
1
9
23

score 2 · Answer 2 · edited May 23 '17 at 11:54

2

Hibernate does not support union.

A feature request for that is open for a decade.

edited May 23 '17 at 11:54

Community

1
1

answered Jul 03 '15 at 05:03

Dragan Bozanovic

23,102
5
43
110

HQL Error in Named Query

2 Answers2