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

Reply via email to