Invalid state for getResultSet

[sumana ar]

hi,
i've a jsp page where in i pass queries to the bean and get back vectors. i retrieve the info from the vector as follows..res is the name of the vector.
int i = 0;
while(i < res.size()) {
variable = res.elementAt(i);
out.println(variable+"<BR>");
i = i+1;
}
i used the same logic in other jsp, which worked fine. but in this page it shows an oracle error 'Invalid state for getResultSet'. when i refresh the jsp page, then every thing works fine... but what could be the problem...am i missing out something...this problem is annoying me..any help is appreciated.
thanks
--sumana reddy.

[Vasudevan Gopalan]

I think it is better to use enumeration instead of while loop.

 
//Assume v is vector
if(v.size()!=0)
{
    for(Enumeration e =v.elements();e.hasMoreElements() :wink: 
    {
                  out.println(e.nextElement());
     
    }
}
 

If still not getting any record check the size of the vector.

[Jeanne Boyarsky]

Did you close the resultset, statement or connection before executing this code? Any one of those would explain the error you are getting.