Re: WG: JDBC 2.0 Scrollable Result Sets -- Slightly going mad -- - Mailing list pgsql-jdbc

From Peter T Mount
Subject Re: WG: JDBC 2.0 Scrollable Result Sets -- Slightly going mad --
Date
Msg-id 986542330.3acd70faaa01e@webmail.retep.org.uk
Whole thread Raw
In response to WG: JDBC 2.0 Scrollable Result Sets -- Slightly going mad --  ("Knud Alex Mueller" <k.mueller@portrix.net>)
List pgsql-jdbc
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/

pgsql-jdbc by date:

Previous
From: "Raghunath T"
Date:
Subject: Unicode support
Next
From: jlemcke
Date:
Subject: Re: Help for java