Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

Next:From: jlemckeDate: 2001-04-06 13:03:57
Subject: Re: Help for java
Previous:From: Raghunath TDate: 2001-04-06 06:58:23
Subject: RE: How connect JDBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group