Entity Manager - create query - nested select

Question

I'm trying to execute the next:

em.createQuery("SELECT processId FROM (SELECT processId FROM table_name WHERE processName like '%abcaccz%')")

But I'm getting:

Method threw 'java.lang.IllegalArgumentException' exception.
unexpected token: ( near line 1, column 23

What is missing here? (This is working in my db client area).

Example, please? Anyway, also this fails: em.createQuery("SELECT processId FROM (SELECT processId FROM table_name WHERE processName like '%abcaccz%') a") — Roni Koren Kurtberg
– Roni Koren Kurtberg, Commented May 19, 2019 at 13:09

Francesc Recio · Accepted Answer · 2019-05-19 14:42:07Z

1

The correct syntax is:

em.createQuery("SELECT processId = (SELECT processId FROM table_name WHERE processName like '%abcaccz%') FROM table_name")

or:

em.createQuery("
  SELECT processId
    FROM table_name
    WHERE processId IN (SELECT processId
                           FROM table_name
                           WHERE processName like '%abcaccz%')")

edited May 19, 2019 at 14:42

answered May 19, 2019 at 14:34

Francesc Recio

2,2552 gold badges15 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Manager - create query - nested select

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related