Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

help with recordset

 
Karthik Veeramani
Ranch Hand
Posts: 132
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic