File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes help with recordset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "help with recordset" Watch "help with recordset" New topic

help with recordset

Karthik Veeramani
Ranch Hand

Joined: Dec 22, 2002
Posts: 132
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...

Thanks<br />Karthik<br />SCJP 1.4, CCNA.<br /> <br />"Success is relative. More the success, more the relatives."
Avi Abrami
Ranch Hand

Joined: Oct 11, 2000
Posts: 1141

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,
I agree. Here's the link:
subject: help with recordset
It's not a secret anymore!