help with recordset

[Karthik Veeramani]

I'm sorry if this is a dumb question, im rather weak in jdbc... Is it possible to position the pointer in the recordset to any index... that is, i want to flip back n forth and get any record i want from the record set... it gave me some error while trying to do that...
i saw a similar post, but i donno if its related to wat i ask... plz help...

[Avi Abrami]

Hi Karthik,
I assume you are referring to a scrollable "ResultSet". First, the JDBC driver (and perhaps also the database) you are using, need to support it. From my experience, I know that Oracle 8i with Oracle's (thin) JDBC driver, and Micro$oft Access 2002 with the JDBC-ODBC bridge driver (from J2SE 1.4.1) support scrollable "ResultSet"s.
In case you are unaware, the Moving the Cursor in Scrollable Result Sets section of the Java Tutorial explains how to create and use scrollable "ResultSet"s.
Hope this has helped you.
Good Luck,
Avi.