Originally posted by Martin Moraga:
However I did not ask to know if I had to use a ResultSet with a JSP or not.
JavaRanch is a learning site. So whether you ask for it or not, you are going to get recommendations regarding best practices. Most people learn by listening to those that have already made the mistakes and share their tales of how to avoid them.
Besides, it's part of the answer. Result sets are cranky, cantankerous beasts and
you should copy the data out of them and send them on their way immediately.
Once you have the data in a more reasonable construct, it's a lot easier to do things like caching and sorting and other stuff. To include, accessing them in a reasonable manner in a JSP.
[ September 29, 2008: Message edited by: Bear Bibeault ]