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

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Knud Alex Mueller <k(dot)mueller(at)portrix(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: WG: JDBC 2.0 Scrollable Result Sets -- Slightly going mad --
Date: 2001-04-06 07:32:10
Message-ID: 986542330.3acd70faaa01e@webmail.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Quoting Knud Alex Mueller <k(dot)mueller(at)portrix(dot)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(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message jlemcke 2001-04-06 13:03:57 Re: Help for java
Previous Message Raghunath T 2001-04-06 06:58:23 RE: How connect JDBC