Hi Ketharinath, I was also doing something similar. Can you suggest which collection objects we can use to store values coming out of database and then send it to the JSP. Can you elaboreate. Can you provide code snippets if you could. Thanks Praveen
----- Original Message ----- From: "Ketharinath Kamalanathan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 10, 2001 11:35 AM Subject: Re: A JSP doubt > 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 > =========================================================================== 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
