我正在尝试使用Hibernate 3和Oracle 10编写此查询。

from Alert alert
where alert.expiration > current_date()
order by alert.priority, alert.updated, alert.name

它正在这样创建SQL-

Hibernate: select alert0_.ANNOUNCEMENTS_ID as ANNOUNCE1_1_, alert0_.ANNOUNCEMENT
S_NAME as ANNOUNCE2_1_, alert0_.ANNOUNCEMENTS_PRIORITY as ANNOUNCE3_1_, alert0_.
ANNOUNCEMENTS_EXPIRATION as ANNOUNCE4_1_, alert0_.ANNOUNCEMENTS_UPDATE_DATE as A
NNOUNCE5_1_ from NYC311_ANNOUNCEMENTS alert0_ where (alert0_.ANNOUNCEMENTS_EXPIR
ATION>current_date()) order by  alert0_.ANNOUNCEMENTS_PRIORITY , alert0_.ANNOUNC
EMENTS_UPDATE_DATE , alert0_.ANNOUNCEMENTS_NAME

当显然有完美的括号时，我会收到所有这些古怪的错误，例如“缺少正确的括号”。

甲骨文为何为此大吃一惊？有没有更好的方法来编写我的HQL查询？