Query q = session.createSQLQuery(sql.toString());
q.setResultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP);
q.setFirstResult(index);
q.setMaxResults(Page.PAGE_SIZE);
q.setFirstResult(index);
q.setMaxResults(Page.PAGE_SIZE);
Query q = session.createSQLQuery(sql.toString());
q.setResultTransformer(CriteriaSpecification.ALIAS_TO_ENTITY_MAP);
q.setFirstResult(index);
q.setMaxResults(Page.PAGE_SIZE);