java - 无法找到命名参数

Question

我无法理解为什么 hibernate 没有找到下面查询的参数“setor”。

hql.append("select top :limite * from MA3OCORT oco,MA4DETOT ocodA " +
           "    where MA4IDOCO=ma3idoco " +
           "    and ocodA.MA4IDODE in (select max(ocodB.MA4IDODE) from MA4DETOT ocodB where ocodA.MA4IDOCO=ocodB.MA4IDOCO and ocodB.MA4IDSIT=:situacao)" +
           "    and (oco.MA3DSSOL like :solicitante or :solicitante is null)" +
           "    and (ocodA.MA4DTDET between :datai and :dataf or :dataf is null)" +
           "    and ocodA.MA4IDSET = :setor" +
           "order by ocodA.MA4DTDET desc");

return em.createNativeQuery(hql.toString(), OcorrenciaDetalhe.class)
       .setParameter("situacao", situacao)
       .setParameter("solicitante",  "%" + solicitanteFiltro + "%")
       .setParameter("datai", dataRespostaFiltro1)
       .setParameter("dataf", dataRespostaFiltro2)
       .setParameter("setor", usuarioLogado.getSetor().getId())
       .setParameter("limite", limit).getResultList();

Answer 1

因为select中有语法错误

这个

"   and ocodA.MA4IDSET = :setor" +
"order by ocodA.MA4DTDET desc");

变成了

'   and ocodA.MA4IDSET = :setororder by ocodA.MA4DTDET desc'

您需要在:setor之后或order之前添加一个空白字符。