java - 如何选择条件等于 null 的地方。

Question

SQL语句:

select * FROM Message
 WHERE senderId = 126 and receiverId = 125
   and dateReceived is null

HQL语句:

 FROM Message
WHERE senderId = :senderId and receiverId = :receiverId
 and dateReceived is null

我遇到了错误。那么如何编写HQL来获得与上述sql语句相同的结果呢？

Answer 1

尝试使用 IS EMPTY 应该可以。