Hello Joshy: The ResultSet object needs a database connection to be maintained. You cannot access the ResultSet object without persistent Connection. So, when you have the ResultSet in the JSP you are trying to have the connection to the database. By this you are hogging the bandwidth and also suing more of your database resources.
Its a fairly good idea to do the iteration in the Java Class then have some collection object passed to the JSP. This eliminates the problems that I have mentioned about previously. Hope this helps. /Ketharinath Kamalanathan ----- Original Message ----- From: "JOSHY MON M C" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 2:34 AM Subject: A JSP doubt > Hi folks, > > Please answer my following questions > 1 .Is it a good practice to use the Resultset object directly on a JSP page > ? ( eg: for iterating employee recordet and displaying employee list ) > > 2. Instead, if I iterate the same recordset in a Jave class and make a List > of Employee object and return back to the page. Will it be a good design. > How is it going to affect the performance. > > Please reply soon. > > Regards > Joshy > > =========================================================================== > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > http://archives.java.sun.com/jsp-interest.html > http://java.sun.com/products/jsp/faq.html > http://www.esperanto.org.nz/jsp/jspfaq.jsp > http://www.jguru.com/faq/index.jsp > http://www.jspinsider.com > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
