Hi. I have a servlet which prompts user for some values, then search the database using entered keys and the display the result back to the user. I want to break results into pieces so it would load more quickly and reduce server loading (generating HTML from 3000 records take quite a few time).
Currently, it's done as this: - select servlet accepts input keys, runs a SQL SELECT, stores returned SQL cursor to the session and redirects to browser servlet. - browser servlet uses c.fetchmany() to get next chunk of data and display it. The 'Next' button does another c.fetchmany() and redirects to itself. These scheme is ugly and has drawbacks. Does someone know a better solution? Main problems are: - can't reliably determine when cursor is no longer needed to close it - can't browse backward (also user can press Back button) PS: Btw, how can I put a link into HTML page to get back (like pressing Back button)? I vaguelly recall that it should be some magic js spell. -- Bst rgrds, M.A.X.: Mechanical Artificial Xenomorph. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ Webware-discuss mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/webware-discuss