You're probably reading after next() returned false.
(*Chris*)
----- Original Message -----
From: "Orozco, Juan Carlos" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 8:54 AM
Subject: Re: [JSP-INTEREST] javax.servlet.ServletException: No data found...
why???? plea se h elp..!!
> Thank you very much..for your help..
> I change to JDBC Oracle thin driver, instead jdbc-odbc bridge,
> and the jsp, begin to populate the list box, but i have this error..
> Internal Servlet Error:javax.servlet.ServletException: Exhausted
Resultset:
>
> what's happening? , maybe the recordset it's too large??
>
> thanks,
>
> Juan
>
>
>
> -----Original Message-----
> From: Atilio Ranzuglia [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 25, 2001 11:12 AM
> To: [EMAIL PROTECTED]
> Subject: Re: javax.servlet.ServletException: No data found... why????
> please h elp..!!
>
>
> Chris:
>
> What you said is true on JDBC 1.0 but not in JDBC 2.0.
>
> JDBC 2.0 allows you to calls the getter method in any
> order, and to navigate through the ResultSet.
>
> There are a lot of new features on JDBC 2.0.
>
> Hope this help
> Atilio
>
>
> --- Chris Pratt <[EMAIL PROTECTED]> wrote:
> > From what I understand, you cannot call a
> > resultSet.getXXX() method more
> > than once on a single value with predictable
> > results. You should probably
> > get it and store it in a variable if you need to use
> > it more than once.
> > (*Chris*)
> >
> > ----- Original Message -----
> > From: "Orozco, Juan Carlos" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Saturday, June 23, 2001 7:38 AM
> > Subject: [JSP-INTEREST]
> > javax.servlet.ServletException: No data found...
> > why???? please h elp..!!
> >
> >
> > > Hi guys,
> > >
> > > I have a problem with the resultSets, when i made
> > the getObject method
> > > more than one time...example:
> > >
> > > String temp="";
> > > String depto="";
> > >
> > > String
> > paisd=(String)rst_loc.getObject("PAIS_ORIGEN");
> > <--may be here
> > >
> > >
> > > while (rst_loc_hasData)
> > > {
> > >
> > > temp =
> > (String)rst_loc.getObject("PAIS_ORIGEN"); <--here is
> > the
> > > problem
> > >
> > > while (paisd.equals(temp))
> > > {
> > >
> > >
> > depto=(String)rst_loc.getObject("DEPARTAMENTO");
> > > %>
> > >
> > listB.addOptions(<%=paisd%>,<%=depto%>,<%=depto%>);
> > > <-- my JavaScript function
> > > <%
> > > rst_loc_hasData =
> > rst_loc.next();
> > >
> > paisd=(String)rst_loc.getObject("PAIS_ORIGEN");
> > > }
> > > }
> > > rst_loc.close();
> > > rst_loc = Statementrst_loc.executeQuery();
> > > rst_loc_hasData = rst_loc.next();
> > > rst_loc_isEmpty = !rst_loc_hasData;
> > > %>
> > >
> > > I don't know why... and is the same thing when i
> > am populate a listbox
> > >
> > >
> > >
> > > <%
> > > String pais = "";
> > <-- I have to
> > > declare this variables because i can't use
> > getObject method
> > > String pais_iso = "";
> > > while (rst_paises_hasData)
> > > {
> > > pais =
> > (String)rst_paises.getObject("PAIS");
> > > pais_iso =
> > > (String)rst_paises.getObject("PAIS_ORIGEN");
> > > %>
> > > <option
> > value="<%=pais_iso%>"><%=pais%></option>
> > > <-- i must can
> > put(String)rst_paises.getObject("PAIS_ORIGEN")
> > directly
> > > <%
> > > rst_paises_hasData
> > = rst_paises.next();
> > > }
> > > rst_paises.close();
> > > rst_paises =
> > Statementrst_paises.executeQuery();
> > > rst_paises_hasData =
> > rst_paises.next();
> > > rst_paises_isEmpty =
> > !rst_paises_hasData;
> > > %>
> > >
> > >
> > > Thanks a lot friends..!!
> > >
> > >
> >
>
===========================================================================
> > > 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
> >
> >
> >
> _________________________________________________________
> > Do You Yahoo!?
> > Get your free @yahoo.com address at
> > http://mail.yahoo.com
> >
> >
> >
>
===========================================================================
> > 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
>
>
> =====
> Ing. Atilio Ranzuglia Buteler
> [EMAIL PROTECTED]
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>
>
===========================================================================
> 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
>
>
===========================================================================
> 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
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
===========================================================================
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
