HQL "is null" And "!= null" on an Oracle column

Question

Does hibernate convert column != null in HQL to a column is null in SQL?

score 105 · Accepted Answer · answered Feb 21 '11 at 13:29

105

That is a binary operator in hibernate you should use

is not null

answered Feb 21 '11 at 13:29

Eduard

score 43 · Answer 2 · answered Feb 21 '11 at 13:26

43

No. You have to use is null and is not null in HQL.

answered Feb 21 '11 at 13:26

JB Nizet

score 15 · Answer 3 · edited Sep 04 '17 at 09:26

15

If you do want to use null values with '=' or '<>' operators you may find the

answer from @egallardo hier

very useful.

Short example for '=': The expression

WHERE t.field = :param

you refactor like this

WHERE ((:param is null and t.field is null) or t.field = :param)

Now you can set the parameter param either to some non-null value or to null:

query.setParameter("param", "Hello World"); // Works
query.setParameter("param", null);          // Works also

edited Sep 04 '17 at 09:26

Luis Filipe

answered Apr 15 '16 at 05:59

Boris Brodski

1

Right answer, but a bit overkill :) I do it if I have no other solutions: If there is only one or two nullable param, i find it better to make many HQL or JPQL queries. – pdem Jan 19 '17 at 11:22

score 1 · Answer 4 · edited May 23 '17 at 12:25

1

No. See also this link Handle conditional null in HQL for tips and tricks on how to handle comparisons with both null and non-null values.

edited May 23 '17 at 12:25

Community

answered Feb 06 '14 at 03:03

egallardo

4 Answers4