Hello there,
I am trying to understand the way the data is fetched from the databse and displaying the data on the client side. I have a DMI which queries the database and returns the data to the listgrid. My intention is to load 100 records everytime to the client side and as it scrolls down then again fetch the next 100 and so on. but in my case all the 1999 data is loaded at once. what am I doing wrong.can somebody please help me to understand the fundamentals.
Below is my DMI java class
But as you can see in the screenshot I have attached there is just one server trip and when I scroll down nothing is changing. I am confused. when I mentioned to get 100 records why has it loaded all the data in the listgrid.
cheers
Zolf
I am trying to understand the way the data is fetched from the databse and displaying the data on the client side. I have a DMI which queries the database and returns the data to the listgrid. My intention is to load 100 records everytime to the client side and as it scrolls down then again fetch the next 100 and so on. but in my case all the 1999 data is loaded at once. what am I doing wrong.can somebody please help me to understand the fundamentals.
Below is my DMI java class
Code:
Query query = hibernateSession.createSQLQuery(select);
query.setResultTransformer(Transformers.aliasToBean(CusNeighbourGroupInfo.class));
List<CusNeighbourGroupInfo> order = query.list();
Integer rowCount = order.size();
dsResponse.setStartRow(0);
dsResponse.setEndRow(100);
dsResponse.setTotalRows(rowCount);
dsResponse.setData(order);
HibernateUtills.getInstance().closeSession();
logger.info("< fetch");
return dsResponse;
cheers
Zolf
Attached Files
Comment