Java EE not compiling a query with the IN operator

Question

I've written a query that works good if used into MySql Workbench, but it won't compile if used in my Java EE project!

Here's the query :

@NamedQuery(name = "Book.findByCourse", query = "SELECT b FROM Book b WHERE b.teaching IN (SELECT T.id FROM Teaching T, Course C WHERE T.course = C.id AND C.id = :course)")

The query works fine, but I've got this error in my Java EE project :

Error compiling the query [...], line 0, column 0: invalid IN expression argument [SubqueryNode Left: null Right: null], expected argument of type [entity.Teaching].

What's wrong with it?

Does the query compile if you replace `:course` with a constant value or a `?` (question-mark character) ? — , Jan 25 '12 at 09:56
Using `?` gives a parsing error, while using a constant value leads to the same error — StepTNT, Jan 25 '12 at 10:13

score 0 · Accepted Answer · edited May 23 '17 at 12:20

0

First of all you are trying to select ids only in your subquery and then compare it to full pojo object (not sure if that's possible at all)

In my opinion you should either got with native query (@NamedNativeQuery) to achieve what you want or use Criteria Builder like for example here

edited May 23 '17 at 12:20

Community

1
1

answered Jan 25 '12 at 10:20

Kris

5,714
2
27
47

Java EE not compiling a query with the IN operator

1 Answers1