Re: Mapping SQL Result Sets to Browsers

["Aaron Bartell" <aaronbartell@xxxxxxxxx>]

> Thanks for the reply.  And please forgive my ignorance.  Couldn't a
reference to the result set be passed just as easily?  I really don't know.

Actually, that is a very good question and my response is going to be based
on my experiences and not necessarily the "real reason" if there is such a
thing.  I don't pass SQL result sets because they aren't part of the Java
Collection hierarchy.  What that basically equates to is that I can't easily
use SQL result sets with other frameworks like the JSF dataTable.  You could
think of converting an SQL result set to a Collection with POJO's as entries
as a way to genericise the result.  I will conclude with the fact that you
will most definitely lose CPU cycles in the process (not a fact I like).

Can anybody add to my statement (either in correction or support)?

Aaron Bartell
http://mowyourlawn.com