S
Simon
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
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