Guyz,
If i call a method from jsp, and the the method is doing query to =
database and return a resultset to the jsp page, does the connection to =
database still alive or not after i typed resultset.close(), =
statement.close() and connection.close() ?
Becoz eventhougt i close the connection but since i return resultset, =
the connection still exist actually, so he suggest to move the data into =
a vector then i can return the vector to jsp. But if i do this, it means =
i need 1 process to move from resultset to vector, it makes my process =
more longer then. Coz if i use resultset i just get the data directly =
from resultset .. what if i got a thousand record, the moving process to =
vector will take time. So anybody can tell if is it true if i used =
resultset, the connection still available even thought i was closed it =
or what ? and what is the best way to return lots data to jsp, using =
vector or resultset..=20
thx
JavaSoft
===========================================================================
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://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
