Hibernate:无法定位命名参数[]

Question

我面临以下错误:

could not locate named parameter [ ]

我的代码是

String[] params = {"PARAM1","PARAM2"}
Query query = session.createQuery("select paramValue from Table where paramName in (:PARAMS) order by FIELD (paramName, :PARAMS)");
query.setParameterList(" ", params);

有人能帮我解决这个问题吗?

Answer 1

必须为参数命名

query.setParameterList("PARAMS", params);

你可以在错误信息中看到空白…