我试图用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
当有明显完美平衡的圆括号时,我会收到所有这些古怪的错误,如“缺少右括号”。
为什么Oracle在这方面出局了?有没有更好的方式来编写我的HQL查询?