Re: JDBC Scrollable ResultSet

On Sat, Sep 13, 2003 at 11:03:02AM +0300, jonathan.lister@vaisala.com wrote:
> Are first() and previous() fully implemented?
>
> My tests indicate that first() will correctly return false if the
> resultSet(TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY) is empty, but if I have
> called next() several times on a non-empty resultSet then a call to first()
> doesn't seem to have any effect, even though it returns true.
>
> pg 7.3.2, latest stable pg73jdbc2
>
> Does anyone have a smart workaround?

Are you also using setFetchSize()? I've noticed that the cursor-based-fetch
implementation that gets used with a non-zero fetchsize doesn't look like it
will work correctly with scrollable resultsets.

-O