I disagree wholeheartedly with this practice for several reasons. First and foremost, the problem with passing the result set directly to the JSP is that you must make sure to close your connections when done. Your JSP might be able to close your result set, but your statement and connection--as a best case scenario--have to wait for the GC. Worst case they stay out there and go stale, but they can still block active threads from accessing the DB when you exceed your max connection count.
Second, what happens if you encounter a SQLException while processing the ResultSet? Error handling is best done at the controller level (when notified by the model, of course). Third, and I've already said this, but processing results belongs in the model. Your view tier should not be your model. This is the whole premise of MVC--don't put your control or business logic in your view! Fourth, a ResultSet in itself is not Serializable, so you don't want to try and pass it around, store it in the session, or any other silly thing like that. So the Best Practice IMHO is to have a model component perform your query, load the results into a generic list of DTO's. It then becomes trivial to display the content of the search results, page back and forth, and so on. It also maintains the integrity and separation of your MVC design. David Hibbs Staff Programmer / Analyst Distributed Applications Development and Support American National Insurance Company > -----Original Message----- > From: Gene Campbell [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 10, 2003 12:41 PM > To: [EMAIL PROTECTED] > Subject: Re: Best practive for presenting a search result to a user > > > If there is a Tag to deal with ResultSets, and you > don't need to post process the data at all, you can > use it in a jsp without needing to write any Java on > the page. It just becomes a DTO, that the controller > hands to the view. Right? > > Best practice in my experience would be use the RS, > and refactor if you need to. But, you should not > import java.sql in your jsps. So, use a wrapper if > you can't find an introspecting tag, or another trick. > > - gene > -- From Marc -- > Hello, > > I would like to know what is for you the best practice > to present to a user the result of a db query (a > ResultSet variable)? > > If, you can take some example of your suggestion, it > will help me to understand... > > thank you in advance > > regards > Marc > > __________________________________ > Do you Yahoo!? > Yahoo! Calendar - Free online calendar with sync to Outlook(TM). > http://calendar.yahoo.com > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]