I have done pagination with hibernate and jsp pager tag lib. It is working fine.
The queries i am using are as follow:
Now i am testing it against 1,00,000 records in the database(mysql).
But when i do the rigrous testing i.e. by clicking on the next button so many times and very fastly i get the following err :
You are creating the transactions but are not commiting or rolling them back.
In the "Method for getting employees based on query",
do
"session.getTransaction().commit();"
after line 12.