'Best' depends heavily on your requirements and database. Lots of people will say lots of different things, but you'll have to weigh it up depending on your problem - eg if you have 5000 records from multiple users, you won't want to be storing the data on the session.
There have been several converations on this in this forum, but also the
Servlets and
JSP forums. First I'd recommend a serach of those forums.
I do have a list of some of these threads stashed somewhere, I'll have a look and post them if I can find them.
Dave.
