应为IDENT，但找到“：”

Question

我正在为我的spring项目构建一个本机查询。有人知道这是什么问题吗？

@Query(value = "SELECT e.first_name as firstName, e.last_name as lastName, jh.start_date as startDate, jh.end_date as endDate, " +
                "j.job_title as jobName, d.department_name as departmentName FROM JOB_HISTORY jh " +
                "JOIN JOBS j ON jh.JOB_ID = j.JOB_ID " +
                "JOIN DEPARTMENTS d ON JH.DEPARTMENT_ID = d.DEPARTMENT_ID " +
                "JOIN EMPLOYEES e ON jh.EMPLOYEE_ID = e.EMPLOYEE_ID " +
                "ORDER BY jh.:sortBy :orderBy")
        List<EmployeeJobView> getAllEmployeeJob(String sortBy, String orderBy);

org.hibernate.hql.internal.ast.QuerySyntaxException：需要IDENT，在第1行第348列附近找到“：”[选择e.first_name作为第一名，e.last_na me作为最后一名，jh.start_date作为开始日期，jh.end_date作为结束日期，j.job_title作为作业名，d.department_name作为Departmentnamefrom JOB_HISTORY jh JOIN JOBS jh jh.job_id=j.job_id JOIN department_id=d.depar TMENT_ID JOIN EMPLOYEES e ON

Answer 1

如果我没弄错，我会用spel重写最后一行：

"ORDER BY jh.?#{[0]} ?#{[1]}"

也请参阅此处https://spring.io/blog/2014/07/15/spel-support-in--data-jpa-query-definitions的SPeL with JPA guide。