Spring Boot data-jpa 和 nativeQuery Postgres cast

Question

我在存储库中有一个自定义的 @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 一起工作？

Answer 1

我发帖后不久就发现了。转义 :: 有帮助。

SELECT * FROM topicaudit_c14001 
WHERE auditdate >= NOW() 
AND auditdate <= NOW() + '1 hour'\\:\\:INTERVAL 
AND accepted_status = 'ACCEPTED' 
AND reminder_sent = FALSE