Are there nonscrollable ResultSets still?

[Gordon Royle]

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?

Thanks

Gordon