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
