Re: Postgresql JDBC driver - Support for Scrollable Result Sets - Mailing list pgsql-jdbc

From Michael Stephenson
Subject Re: Postgresql JDBC driver - Support for Scrollable Result Sets
Date
Msg-id Pine.LNX.4.30.0101241125350.11798-100000@tirin.openworld.co.uk
Whole thread Raw
In response to Postgresql JDBC driver - Support for Scrollable Result Sets  ("Ramachandra K.B.S" <ram@meritsystems.com>)
Responses Re: Re: Postgresql JDBC driver - Support for Scrollable Result Sets  (Peter T Mount <peter@retep.org.uk>)
List pgsql-jdbc
> In a current development project, we need the 'Scrollable Resultset'
> functionality, which does not seem to exist in the driver for PostgreSQL
> 7.0.3.  We basically want to retrieve a set of records into a result set
> and then browse through the records in the result set.

One of us is confused.

'TYPE_SCROLL_INSENSITIVE' ResultSets are already supported in the
PostgreSQL 7.0.3 release drivers (jdbc2). ie previous(), next(),
relative(), absolute(), afterLast(), beforeFirst(), isAfterLast(),
isBeforeFirst(), isFirst(), isLast(), last() are all implemented.

> Is it available in the driver for PostgreSQL 7.1?  Will it be available
> in the release version.

Assuming we haven't got our wires crossed somewhere, yes, and yes.

Michael Stephenson      mstephenson@openworld.co.uk
Developer   -    Web Applications    -   Open World
Tel: +44 1225 444 950         Fax: +44 1225 336 738


pgsql-jdbc by date:

Previous
From: "Ramachandra K.B.S"
Date:
Subject: Postgresql JDBC driver - Support for Scrollable Result Sets
Next
From: Bruce Momjian
Date:
Subject: Re: [BUGS] JDBC PreparedStatement.setMaxRows() affects other objects instantiated from this class and it's parent class