Re: WG: JDBC 2.0 Scrollable Result Sets -- Slightly going mad --

Quoting Knud Alex Mueller <k.mueller@portrix.net>:

> It worked fine with my development Plattform using JDBC-ODBC Bridge on
> SQL-SERVER 7.0 as well as ACCESS 2000. Now deployed on the Linux machine
> the
> exception is returned, that the function is not implemented.

Implemented in 7.1.

>
> I use rs.last();rs.absolute();rs.next();rs.getRow();
>
> What can I do ?

A workaround for 7.0.3 and earlier is not request the types, ie getStatement().

In the PostgreSQL driver it defaults to TYPE_SCROLL_SENSITIVE anyhow, and these
methods will always work. 7.1 implements the alternate getStatement you are
trying to use so that in 7.2 updateable resultsets can be implemented.

Peter


--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/