Hi, I am facing a problem to manage query result and split them in more than one page. I have a jsp page where the user can insert research parameters and submit the query. Then the Jsp page show all the rows extracted from the db. But How to show all the record when they are thousands? The natural answer is just to use multiple pages and to show about 50 rows at a time. I wonder if some of you already faced the problem. I thought several possibility, but they don't look so good. I can use a query that extracts only a portion of my data each time. But in that way I run a lot of query on the DBMS. I can use a stateful session bean to hold a connection, opena cursor and fetch the data as I need them. But I don't want to create so much session bean (I expect at least 1000 user, and the application is full of research page). I can still use a stateless session bean and extract all the data I need and store them (let's say in a collection) and then use them as I need. But what happens when the records are millions (it could anyway happen). I will really appreciate your help. Regards. VIncenzo Scervo. =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". Some relevant FAQs on JSP/Servlets can be found at: http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.html http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
