Re: [eclipselink-users] Order By with DB2/400 DataBase

[Lexuor76 <lexuor76@xxxxxxxxx>]

public class OrderDAO {
    private EntityManager em = EMF.getInstance().createEntityManager();
    private PagingList<OrderEntity> pagingList;

    public int initPagingListForOrderById(int pageSize) {
        TypedQuery<OrderEntity> query = em.createQuery("SELECT o FROM
OrderEntity o ORDER BY o.id DESC", OrderEntity.class);
        int size = ((Long) em.createQuery("SELECT COUNT(o) FROM OrderEntity
o").getSingleResult()).intValue();
        pagingList = new PagingList<OrderEntity>(query, size, pageSize);
        int pageCount = pagingList.getPageCount();
        return pageCount;
    }

    public List<OrderEntity> getPage(int pageNum) {
        if (pagingList != null) {
            return pagingList.getPage(pageNum);
        } else {
            return null;
        }
    }
}
-- 
View this message in context: http://old.nabble.com/Order-By-with-DB2-400-DataBase-tp33385840p33400019.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.