java - 想要将 SQL 转换为 Hibernate 查询语言

Question

我有一个要求，必须将 SQL 转换为 HQL。

SQL查询如下:

select RT.tableNumber, temp.confirmationNumber from ReservationTable RT, (select R.tableNumber, R.confirmationNumber from Reservation R where R.date = 'someDate' and R.time = 'someTime' and R.reservationStatus = 'CONFIRMED') as temp where RT.tableNumber = temp.tableNumber and RT.tableNumber = 'someTableNumber' ;

我尝试将其转换为以下 HQL:

select RT.tableNumber, temp.confirmationNumber from ReservationTable RT, (select R.tableNumber, R.confirmationNumber from Reservation R where R.date = :param1 and R.time = :param2 and R.reservationStatus = 'CONFIRMED') as temp where RT.tableNumber = temp.tableNumber and RT.tableNumber = :param3";

但是当我通过 Eclipse 运行此 HQL 时，我收到以下错误行:

ERROR: line 1:102: unexpected token: (

ERROR: line 1:146: unexpected token: from

SEVERE: Servlet.service() for servlet [dispatcher] in context with path [/RRSRestApp] threw exception [Request processing failed; nested exception is org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: ( near line 1, column 102 [select RT.tableNumber, temp.confirmationNumber from com.kartik.restaurant.model.ReservationTable RT, (select R.tableNumber, R.confirmationNumber from com.kartik.restaurant.model.Reservation R where R.date = :param1 and R.time = :param2 and R.reservationStatus = 'CONFIRMED') as temp where RT.tableNumber = temp.tableNumber and RT.tableNumber = :param3; ]] with root cause org.hibernate.hql.internal.ast.QuerySyntaxException: unexpected token: ( near line 1, column 102 [select RT.tableNumber, temp.confirmationNumber from com.kartik.restaurant.model.ReservationTable RT, (select R.tableNumber, R.confirmationNumber from com.kartik.restaurant.model.Reservation R where R.date = :param1 and R.time = :param2 and R.reservationStatus = 'CONFIRMED') as temp where RT.tableNumber = temp.tableNumber and RT.tableNumber = :param3; ]

谁能帮我解决这个问题吗？

Answer 1

根据 hibernate 文档，HQL 子查询只能出现在 select 或 where 子句中。

for more detail please follow hibernate documentation