problem in reverse traversing of resultset

Discussions

General J2EE: problem in reverse traversing of resultset

  1. problem in reverse traversing of resultset (1 messages)

    I am using jdk 1.3 and classes12.zip of oracle.

    i am calling database procedure from a java code.

    (CallableStatement) conn.prepareCall("{ ? = call F_VALIDATE_USER(?,?,?) }", ResultSet.TYPE_SCROLL_INSENSITIVE , ResultSet.CONCUR_READ_ONLY);

    In database procedure, cursor is opened and only 2 records are fetched.
    the procedure returns this cursor back to java code.

    In java code, cursor is returned in resultset.

    When i am trying to use resultset.previous(), it gives me some error like invalid operation previous performed on forward only cursor.

    Now the problem is, How will i get the records in java which i already fetched in database.
  2. Have you tried calling rs.last() before trvareing ?