Hi all,

Iam new to Hibernate ,I need to implement pagination.My DAO class returning the list which contains all the records from here it is returning to the controller from there to JSP.
Please can any send me the code to implement pagination, i gone through the all the forums but iam not getting the idea how to fit that into my application.



Thanks in advance

see the reference

iam unable to find any sol at your blog.could please send me the exact link



thanks

In the criteria object you can setMaxResults() and setFirstResult().

http://www.hibernate.org/hib_docs/v3/api/org/hibernate/Criteria.html

doc reference,

http://www.hibernate.org/hib_docs/v3/reference/en/html/objectstate.html#objectstate-querying-executing-pagination

Thanks for your reply,


public List getTransactions(TransactionQueryDto transactionQuery){
List relatedOperations = null;
try {
String strQuery = ALL_TRANS_QUERY + getWhereClause(transactionQuery);
Session session = HibernateUtils.getInstance().currentSession();
Query objQuery = session.createQuery(strQuery);
/*
int totalRecords=relatedOperations.size();
objQuery.setFirstResult(0);
objQuery.setMaxResults(totalRecords);
*/
if(transactionQuery.isIncludeDate()){
if(transactionQuery.getFromDate()!=null){
objQuery.setDate("fromDate", transactionQuery.getFromDate());
}
if(transactionQuery.getToDate()!=null){
objQuery.setDate("toDate", transactionQuery.getToDate());
}
}
System.out.println("objQuery: "+objQuery);
relatedOperations = objQuery.list();


} catch (HibernateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return relatedOperations;
}

this is my method whihc is returning all the records through the list..

please suggest me how to fit that code in to this



Thanks

can you have overloaded version of your given method as shown below, chech setting of fist and max results

public List getTransactions(TransactionQueryDto transactionQuery, int intFirstResult, int maxResults){
List relatedOperations = null;
try {
String strQuery = ALL_TRANS_QUERY + getWhereClause(transactionQuery);
Session session = HibernateUtils.getInstance().currentSession();
Query objQuery = session.createQuery(strQuery);
/*
int totalRecords=relatedOperations.size();
objQuery.setFirstResult(0);
objQuery.setMaxResults(totalRecords);
*/
if(transactionQuery.isIncludeDate()){
if(transactionQuery.getFromDate()!=null){
objQuery.setDate("fromDate", transactionQuery.getFromDate());
}
if(transactionQuery.getToDate()!=null){
objQuery.setDate("toDate", transactionQuery.getToDate());
}
}

objQuery.setMaxResults(intMaxResult)
objQuery.setFirstResult(intFirstResult).

System.out.println("objQuery: "+objQuery);
relatedOperations = objQuery.list();


} catch (HibernateException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return relatedOperations;
}

Thanks for u r reply i will try that method ....

[quote="hyper"]Thanks for u r reply i will try that method ....[/quote]

I tried that overloaded method but how can i pass that maxResults from a JSP with out executing a query .(ie; we don't know the maxResults value while passing from the JSP we can only pass the firstResults Value)


Please reply ASAP