HQL意外标记”（“子查询选择

Question

我有这个问题。将其从sql查询转换为hql。我有以下错误“意外标记：（靠近第2行第列）”

String query = "SELECT MAX(number)\n" +
        "  FROM (SELECT number FROM EmployeeTripCard \n" +
        "        WHERE EXTRACT(YEAR FROM issueDate) = '2015'\n" +
        "        UNION ALL\n" +
        "        SELECT trip_card_number FROM PostgraduateTripCard\n" +
        "        WHERE EXTRACT(YEAR FROM issueDate) = '2015'\n" +
        "        UNION ALL\n" +
        "        SELECT trip_card_number FROM StudentTripCard \n" +
        "        WHERE EXTRACT(YEAR FROM issueDate) = '2015'\n" +
        "        )";




Integer result = (Integer) getSessionFactory().getCurrentSession().createQuery(query).uniqueResult();

我不知道怎么了

Answer 1

我的坏Vytsalo，没有看数据库标签。从句中不支持HQL子查询

请注意，HQL子查询只能出现在select或where子句中：Hibernate查询语言