How to pass a ResultSet from a servlet to jsp

[4345487]

Hi,

I hope someone can help me with this question.

Does anybody knows how to pass a ResultSet from a servlet to a jsp using a session. I can pass a string OK.

For a string I do this in the servlet:

HttpSession session = request.getSession(true);
session.setAttribute("Test", "test string.........."
RequestDispatcher disp;
disp = getServletContext( ).getRequestDispatcher("/XX.jsp"
disp.forward(request, response);


Then in the JSP page i do this.

<%=session.getAttribute(&quot;Test&quot%>

and it works OK. But I need to pass a resultset

Thanks

 

[Wiszh]

A session attribute does not have to be a string.

But it is probably not a good idea to send the record set to the jsp. It is better to copy all of the recordset data into an object (a vector or hashmap may work) and send that to the JSP.

Good Luck

 

[Hattusas]

What Wiszh says is right.In addition to that don't forget to close your statement after you copy your records.

java.sql.Statement stmt = ....... ;
java.sql.ResultSet rs = stmt.executeQuery(&quot;....&quot;
...
...
...
...
stmt.close();
/* then go to your jsp page...

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr