I need your help for the scenario i am explaining here.
I have search form, from here user will search for the records by giving search options which will featch the records from the database. I am using display tag library to display them as a table in jsp. I am using this because i need pagination and exporting fetaures.
I am buillidng the collection object from the result set and put that object in session which i feed to display tag to display them.
But here the problem is, for small and medium no of records it is ok, but if the records are million i am getting out of memory or heap size error.
so I need your help to overcome this problem. Please rember i need to let the user to export the records in csv and excel and need to do pagination as it is very hard to see all the millon records in single page.