I notice that Jconnect (as all JDBC drivers that I know of only does)
next() for fetching from cursors. I assume that this is a specification
conformance thing.

My question is this, if I want to do some fancier scrolling, it seems to
me that I could subclass ResultSet and implement my own methods that
would "fake" backward, relative, and absolute scrolling. I would do
this by executing a statement that would move the cursor position to the
row "above" the one that I want to move to, and then call the next()
method. So for example my previous() method would actually create and
execute a statment that did a Fetch Relative(-2) and call the next().

Other than having no way to move to position 0 (before the first row) Is
there any reason why this won't work?

Bill Hastings
bill@emek.org