SQL UNION in JPA2 Criteria API

Asked Dec 28 '13 at 07:24

Active Jan 01 '14 at 16:26

Viewed 2,799 times

I have to join two result sets coming from different database tables, something like:

SELECT a,b FROM abtable UNION ALL SELECT c,d FROM cdtable;

My current working solution is to have 2 queries and to join the resultlists (java.util.List) in java. But for the sake of performance and uniform coding patterns I would like to do this in JPA2 using the criteria API.

The UNION keyword doesn't seem to be supported in JPA2 Criteria API? Is there any alternative of doing this using JPA2 Criteria API?

edited Jan 01 '14 at 15:56

asked Dec 28 '13 at 07:24

Hubert Schumacher

1,683
1
16
25

JPA2 does not support UNION – vzhilin Dec 28 '13 at 07:40
Use the answer (using EclipseLink) of this question: http://stackoverflow.com/questions/18958614/union-to-jpa-query – sarwar026 Dec 28 '13 at 08:21
I had the same problem to solve, with this I could make the union https://stackoverflow.com/a/55302501/5486945 – yOshi Mar 22 '19 at 15:15

SQL UNION in JPA2 Criteria API

0 Answers0