Hello  Manu,

In JDBC 2.0 you have the option to move the cursor.
I never tried  it yet but it's written in the Java tutorial.

Regards,
Gilad.


        -----Original Message-----
        From:   Manu Tayal [SMTP:[EMAIL PROTECTED]]
        Sent:   Tuesday, May 04, 1999 7:41 AM
        To:     [EMAIL PROTECTED]
        Subject:        A simple query

        Hi,
          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

Reply via email to