Juan:
The problem you are facing now can be easy or
difficult to resolve.
It can be that you are trying to read the ResultSet
with no data on it.
Or, in the worst case, you can have the problem I had
a few weeks ago. The exception was the same, I were
working on a PreparedStatement (about 20 lines).
It never work, it was always the same output. If I try
it like a regular Statement it worked fine.
Looking for a solution I enter on Oracle's Metalink
(one of the million sites searched) and the solution
encoutered there was:
"... the problem appeared and dissappeared
misteriously ..." from some other guys.
So I have to stay cool and make it a regular
Statement.
I could not find any other solution, if someone here
knows one please let me know, thanks.
Hope this help
Atilio
--- "Orozco, Juan Carlos" <[EMAIL PROTECTED]> wrote:
> 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]
>
>
=== message truncated ===
=====
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
