You can't roll-back to the first pointer of the resultset again. You have
to execute Statement.executeQuery method to get the resultset again. The
workaround is to store the resultset values in a vector.
Sabbir
> I have newly started working with oracle with JDBC. I made a select
> query and got a ResultSet. I used the ResultSet for printint the result.
> I used next() function to get to the next row. After I have printed all
> the results the cursor is on the last row. Now I want to use the same
> resultset again. How do I make the cursor to point to the first row again.
> I was unable to find any function for it. Do I have to query again to get the
> resultset? Is there a work arround to use the same resultset again? Please
> help..
>
> Thanks in advance,
>
> Manu.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> # MANU TAYAL | WIPRO INFOTECH #
> # | 30,Mission Road, 1st Main, #
> # Software Engineer | S.R.Nagar, #
> # | Bangalore-560027,India. #
> # Technology Solutions | #
> # | TEL: 080-2241730/2275590 #
> # WIPRO INFOTECH. | EXT: 3322,3321,3323 #
> # | E-Mail: [EMAIL PROTECTED] #
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> ___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
