actually you have a typo it looks like in one line you are using
rs = cs.getResultSet(); and then you use
rs = ps.getResultSet();
so ps should be cs?
Casey Kochmer
[EMAIL PROTECTED]
>From: Jimmi Dyson <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Multiple results sets
>Date: Tue, 13 Jun 2000 17:42:54 +0100
>
>Thanks, but is that not what I have done?
>
> 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 (cs.getMoreResults()) {
> > rs = ps.getResultSet();
> > ....do more stuff....
> > }
> > }
>
> -----Original Message-----
> From: casey kochmer [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, June 13, 2000 5:25 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Multiple results sets
>
> retrieving multiple results is very easy, You just need to use the
> getMoreResults function.
>
> a very simplified code snippet would look like:
>
> // get the first result set
> boolean lb_found_rs;
> lrs_data = luo_stmt.getResultSet();
>
> //logic to do what you want with current result set
>
> // Move on to next result set
> lb_found_rs = luo_stmt.getMoreResults();
> lrs_data = luo_stmt.getResultSet();
>
> Casey Kochmer
> [EMAIL PROTECTED]
>
> >From: Jimmi Dyson <[EMAIL PROTECTED]>
> >Reply-To: A mailing list about Java Server Pages specification
>and
> > reference <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: Re: Multiple results sets
> >Date: Tue, 13 Jun 2000 09:10:14 +0100
> >
> >That works for a single result set with multiple rows, but how
>about
> >retrieving multiple result sets?
> >
> > -----Original Message-----
> > From: Irfan Mohammed [SMTP:[EMAIL PROTECTED]]
> > Sent: Monday, June 12, 2000 7:00 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Multiple results sets
> >
> > in order to read all the records returned by the
>execution
>of a
> >query do
> > this
> > while(rs.next()){
> > do whatever
> > }
> >
> > rs.next() advances the pointer to the next record in the
>result
> >set
> >and that
> > way you can go till the end of the result set.
> >
> > You could read the api under java.sql.* to understand
>this
> >function
> >better.
> >
> > Irfan
> >
> > -----Original Message-----
> > From: Jimmi Dyson [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, June 12, 2000 4:13 AM
> > To: [EMAIL PROTECTED]
> > Subject: Multiple results sets
> >
> >
> > 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 (cs.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
> >
> >
>
> >===========================================================================
> > 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
> >
>
> >===========================================================================
> >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
>
>
>________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at
>http://www.hotmail.com
>
>
>===========================================================================
> 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
>
>===========================================================================
>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
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
===========================================================================
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
