Hi,

I am trying to understand the implications of processing a ResultSet
in a JSP given that the ResultSet is created in a servlet, and then
placed in the request to provide access to the JSP.
 
My confusion is how the closure of the ResultSet is managed.  I am
aware that the standard procedure would be to open a connection,
execute a statement, and then process the results, before closing the
connection, statement, and result set in the servlet code.  As the
ResultSet object is required by the JSP where should I handle closing
it?  It seems very messy to create the ResultSet in the servlet, and
then close it in the JSP.

Any thoughts/suggestions are much appreciated.

Thanks,
Simon