• Post Reply Bookmark Topic Watch Topic
  • New Topic

Scrolling through a ResultSet

 
George Larry
Ranch Hand
Posts: 52
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm trying to create a ResultSet that I can scroll through...
I know by default ResultSets are set up to be read Forward_Only (so I could only use rs.next()), but I'd like to be able to use rs.previous(), and rs.first().
I've tried setting up a Statement like this:

But I get some AbstractMethodError and a servlet exception: oracle.jdbc.driver.OracleConnection.createStatement...
... which is not very helpful. I don't understand what I'm doing wrong.
Has anybody out there ever successfully created a scrollable ResultSet? If so... could you help me out?
Thanks a bunch!
 
Dan Richardson
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have implemented a scrollable ResultSet. Your code looks good. You may want to make sure the driver you are using is JDBC 2.0 compliant. Scrollable ResultSets were not introduced until JDBC 2.0. I noticed you are using Oracle drivers. If you use the classes12.zip (or newer versions if available) file from Oracle for your drivers, you should be okay.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!