Re: scollable result sets

I read someplace that the CVS version may support it. Unfortunately,
gborg seems to be down for the past day or so. Looking through the
code, I see things like:

while (x_rset.next()) {
x_rset.previous()
function_that_calls_next(x_rset)
}

Is there a better way to do this? With result pointers from other
languages, like perl, python, php, I know the size of the result so I
can choose the type of loop I want to use. Is there a better way to
loop through a result set and have a another function call next?

Matt

Koth, Christian (DWBI) wrote:

> Matt,
> no they are not broken.
> But AFAIK a ScrollableResultSet with Postgres JDBC supports forward
> only. Try again with different settings and of course don't call
> previous().
> If you need scroll back functionality you could use cursors.
> Christian
>
> ------------------------------------------------------------------------
> *Von:* pgsql-jdbc-owner(at)postgresql(dot)org
> [mailto:pgsql-jdbc-owner(at)postgresql(dot)org] *Im Auftrag von *Matt
> Chambers
> *Gesendet:* Dienstag, 5. September 2006 23:16
> *An:* pgsql-jdbc(at)postgresql(dot)org
> *Betreff:* [JDBC] scollable result sets
>
> Are they broken in 8.1? I no matter what I do Postgresl throws an
> exception with calls to functions like previous() and last().
> x_conn.prepareCall ( os_query, ResultSet.TYPE_SCROLL_INSENSITIVE,
> ResultSet.CONCUR_READ_ONLY );
> --
> *Matt Chambers <chambers(at)imageworks(dot)com>*
> *Sony Pictures Imageworks*
> Software Engineer
>
>
>
>