EntityManager convert 'is' and 'is not' operators to = and <> How to prevent such case?

Asked Aug 15 '17 at 19:46

Active Aug 15 '17 at 19:52

Viewed 43 times

I have the following hql :

SELECT obj FROM com.domain.view.DomainClass obj  WHERE  obj.x  LIKE  :p1 AND  obj.y is not :p2 AND  obj.z = :p3 ORDER BY a DESC

while the result from hibernate is:

select obj0_.a as a_, obj0_.b as b_ from obj_table obj0_ where (obj0_.x like ?) and obj0_.y<>? and obj0_.z=? order by obj0_.a DESC

note that the 'is not' (an also 'is') is converted to <> and = which doesn't work with null values

The query is actually generated from TypedQuery class. My question is how to prevent JPA/Hibernate entityManager from converting 'is' and 'is not' to = and <>?

edited Aug 15 '17 at 19:52

asked Aug 15 '17 at 19:46

Muhammad Bekette

1,396
1
24
60

What is your question? – luk2302 Aug 15 '17 at 19:48
I want to enforce the is and is not on the entity manager – Muhammad Bekette Aug 15 '17 at 19:51
You might want to add that both to the question as well as the title, right now both are just *statements*. – luk2302 Aug 15 '17 at 19:52
Why is this question tagged [tag:mysql]? – Michael - sqlbot Aug 16 '17 at 01:16
@Michael-sqlbot well, this problem happens with mysql only as mysql return false for columnx=null unlike oracle. – Muhammad Bekette Aug 16 '17 at 20:46

EntityManager convert 'is' and 'is not' operators to = and <> How to prevent such case?

0 Answers0