How to go to previous record

Hi
In Java I am using Oracle as my backend and I can go to next record, but I am not able to go to the previous record. I tried using rs.previous() method where rs is the object of ResultSet type but doesn't work. I heard about the setFecthDirection() method but how to use this I dont know.
If anyone of you knows please help me out.
Dharam

You can only go backwards if the driver you are using fully supports JDBC 2.0. If I recall, the Oracle drivers are not fully JDBC 2.0 compliant. Check the Oracle web site for details of which functions are not supported.

You can always keep a copy in your code, either of just the previous result, or of all the results in the resultset. Then you can traverse at will.

You can use Connection.createStatement(int resultSetType, int resultSetConcurrency) method to create a scrollable ResultSet.

Originally posted by Thomas Paul:
You can only go backwards if the driver you are using fully supports JDBC 2.0. If I recall, the Oracle drivers are not fully JDBC 2.0 compliant. Check the Oracle web site for details of which functions are not supported.

FYI, Oracle drivers do have most of the JDBC 2.0 functionality.
http://technet.oracle.com//tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm#_29_

of course, it depends on which drivers you are actually using.

------------------
Moderator of the JDBC Forum