Win a copy of Murach's Python Programming this week in the Jython/Python forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Scrolling through a ResultSet  RSS feed

 
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.
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!