wood burning stoves 2.0*
The moose likes JDBC 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
Bookmark "help with recordset" Watch "help with recordset" New topic
Author

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: 1121

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: help with recordset
 
Similar Threads
Can your java function return a resultset?
using gzip to compress results
determing # of rows in recordset
transfer a set of records(.mdb file) from client to server
Passing a recordset to a class