意外标记：hql中存在限制错误

Question

        List<AC_Customer> lastAC_CustomersList = session.createQuery("from AC_Customer order by customer_pk DESC LIMIT 1").list()

当我执行此操作时，我遇到了这个错误，请任何人告诉我hql查询的错误。

组织。冬眠hql。内部的ast。QuerySyntaxException：意外标记：第1行第65列附近的限制[来自com.softlogic.models.AC\u Customer order by Customer\u pk DESC LIMIT 1]

Answer 1

组织。冬眠hql。内部的ast。QuerySyntaxException：意外标记：第1行第87列附近的偏移量[来自om.omantel.prodsheet.models.RtcsProduct，其中status=1 order by TRACKING\u ID DESC OFFSET 1 ROWS FETCH NEXT 5 ROWS]

    @SuppressWarnings("unchecked")
    @Override
     public List<RtcsProduct> pagination(int page_id, int total) {
    String listsql = "FROM RtcsProduct where status=1 order by TRACKING_ID DESC OFFSET "+page_id+" ROWS FETCH NEXT "+total+" ROWS ONLY";
    Session session = null;
    List<RtcsProduct> productlist = null;
    try {
    if (session == null) {
        session = sessionFactory.openSession();
        session.beginTransaction();
        productlist = session.createQuery(listsql).list();
        session.getTransaction().commit();

    }
    }catch(Exception ex) {
        ex.printStackTrace();
    }

    return productlist;
}

Answer 2

HQL不知道LIMIT您必须以以下方式使用setMax结果：

List<AC_Customer> lastAC_CustomersList = session
    .createQuery("from AC_Customer order by customer_pk DESC")
    .setMaxResults(1)
    .getResultList()

Answer 3

尝试使用以下

session.createSQLQuery("select * from AC_Customer order by customer_pk DESC LIMIT 1").list();