Search code examples
javahibernate-criteria

Hibernate Criteria query to find the last but one row for the given empid

I need to get the last but one record for the user (Requisition id is unique) and I am passing the Employee id to get the record.

Here's what I tried :

Requisition r = new Requisition();
session=super.getSession();
Transaction trans=session.beginTransaction();
Criteria q = session.createCriteria(Requisition.class);

q.setMaxResults(1);
r = (Requisition)q.uniqueResult();

Could someone please help me find the error?

Solution

  • Ok, let me answer the above question :

    Hope this helps somebody:

    session=super.getSession();

    Transaction trans=session.beginTransaction();

    Criteria q = session.createCriteria(Requisition.class);

    q.setFirstResult(1);

    q.setMaxResults(1);

    q.add(Restrictions.eq("empID", empid));

    q.addOrder( Order.desc("reqID") );

    r = (Requisition)q.uniqueResult();