Are there nonscrollable ResultSets still?
Posted by: Gordon Royle
Date: August 24, 2006 06:55AM

A very simple question...

I am just experimenting with Connector/J 5.0.3 (on MacOS X, MySQL 5.0.22, Java 1.5).

I run a query on the database and get back a ResultSet object which I called "rs".

When I call "rs.getType()" it returns 1003 which is the value for "ResultSet.TYPE_FORWARD_ONLY" which is what I expected.

Trouble is, the actual ResultSet itself is perfectly scrollable.. I can call "rs.previous()", "rs.absolute(x)" and all those other things that a forward-only cursor should not be able to do.

It may sound a bit churlish to be complaining that my ResultSet can do MORE than it advertises, but I just have this nagging feeling that it means that I don't understand something, and this may come back to bite me later..

Any ideas?



Options: ReplyQuote

Written By
Are there nonscrollable ResultSets still?
August 24, 2006 06:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.