我在存储库中有一个自定义@Query
,如下所示:
SELECT * FROM topicaudit_c14001
WHERE auditdate >= NOW()
AND auditdate <= NOW() + '1 hour'::INTERVAL
AND accepted_status = 'ACCEPTED'
AND reminder_sent = FALSE
当我运行这个时,我得到异常:
org.hibernate.QueryException:
Not all named parameters have been set: [:INTERVAL]
显然,它将::INTERVAL
强制转换(Postgresql(解释为命名参数,并且由于我没有提供参数,因此无法触发查询。
如何编写此查询以使其与 JPA 一起使用?
我在发布后不久就发现了它。逃离::
会有所帮助。
SELECT * FROM topicaudit_c14001
WHERE auditdate >= NOW()
AND auditdate <= NOW() + '1 hour'\:\:INTERVAL
AND accepted_status = 'ACCEPTED'
AND reminder_sent = FALSE