Hi.
After executing a stor proc with multiple ResultSets selected, how do you
get each of the ResultSets back? The code below gets back the first
resultset selected by P_dindin, but not the second. What am I doing wrong?
ps.getMoreResults() is true when it is called, but rs1 never gets any
results back.
My code that I thought was correct looks like this:
try {
Class.forName(...NameOfDriver...).newInstance();
Connection con = DriverManager.getConnection(...URL...);
CallableStatement cs = con.prepareCall("{call P_dindin}");
ResultSet rs;
if (cs.execute()) {
rs = cs.getResultSet();
.....do stuff.......
if (ps.getMoreResults()) {
rs = ps.getResultSet();
....do more stuff....
}
}
} catch (Exception ex) {....}
Thank you in advance.
Jimmi Dyson
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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