What's the best way to return a result from a query on a bean to a JSP page? Returning a ResultSet to the JSP page or returning an ArrayList containing the result or something else?

John Zukowski

Returning a ResultSet requires the Connection to not be reused / remain open and is not a viable option. Consider caching your results in something that allows you to paginate through multiple pages of results.