ResultSet processing/closure in JSP

From: Simon (simon.lambert_at_gmail.com)
Date: 01/12/05

  • Next message: Joe Weinstein: "Re: ResultSet processing/closure in JSP" 
    Date: 11 Jan 2005 15:11:07 -0800

    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

  • Next message: Joe Weinstein: "Re: ResultSet processing/closure in JSP"

    Relevant Pages

    • Re: ResultSet processing/closure in JSP
      ... > I am trying to understand the implications of processing a ResultSet ... > placed in the request to provide access to the JSP. ... > connection, statement, and result set in the servlet code. ...
      (comp.lang.java.programmer)
    • Re: ResultSet processing/closure in JSP
      ... > I am trying to understand the implications of processing a ResultSet ... > placed in the request to provide access to the JSP. ... Otherwise, in the Servlet, go through the results and put them somewhere ...
      (comp.lang.java.programmer)
    • Re: ResultSet processing/closure in JSP
      ... now from my jsp i call the open method using an object of same class do th ... > I am trying to understand the implications of processing a ResultSet ... > aware that the standard procedure would be to open a connection, ... > connection, statement, and result set in the servlet code. ...
      (comp.lang.java.databases)
    • Re: ResultSet processing/closure in JSP
      ... > I am trying to understand the implications of processing a ResultSet ... > placed in the request to provide access to the JSP. ... > execute a statement, and then process the results, before closing the ... > connection, statement, and result set in the servlet code. ...
      (comp.lang.java.programmer)
    • Re: ResultSet processing/closure in JSP
      ... > I am trying to understand the implications of processing a ResultSet ... > placed in the request to provide access to the JSP. ... > execute a statement, and then process the results, before closing the ... > connection, statement, and result set in the servlet code. ...
      (comp.lang.java.databases)