Thread: RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets

RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets

From
"Ramachandra K.B.S"
Date:
Quoting Peter Mount <peter@retep.org.uk>
> Quoting Michael Stephenson <mstephenson@tirin.openworld.co.uk>:

> > > 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.

> Whops, my wires were crossed just now. I was thinking of
UpdateableResultSet ;-)
>
> oh hum...

Wires are only somewhat crossed.

I was trying

createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_READ_ONLY);

Go the 'Method Not Implemented' error.

Tried variations with TYPE_SCROLL_INSENSITIVE and CONCUR_UPDATABLE, but
got the same error.

Checked the www.retep.org.uk site.  It said Peter is working on
scrollable result sets.

Hence I jumped to the conclusion that scrollable result sets (sensitive
or insensitive) were not supported.

Thanks and regards
Ram


RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets

From
Michael Stephenson
Date:
> I was trying
>
> createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
> ResultSet.CONCUR_READ_ONLY);
>
> Go the 'Method Not Implemented' error.

Yes createStatement(int, int) will always fail in 7.0.3 (which is the most
recent version I have here).

createStatement(), with no parameters, will return a ResultSet of the type
you requested above.

> Hence I jumped to the conclusion that scrollable result sets (sensitive
> or insensitive) were not supported.

Understandably.

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


RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets

From
Peter T Mount
Date:
Quoting "Ramachandra K.B.S" <ram@meritsystems.com>:

>
> Quoting Peter Mount <peter@retep.org.uk>
> > Quoting Michael Stephenson <mstephenson@tirin.openworld.co.uk>:
>
> > > > 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.
>
> > Whops, my wires were crossed just now. I was thinking of
> UpdateableResultSet ;-)
> >
> > oh hum...
>
> Wires are only somewhat crossed.
>
> I was trying
>
> createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
> ResultSet.CONCUR_READ_ONLY);
>
> Go the 'Method Not Implemented' error.

Fixed about 1 1/2 weeks ago in current cvs, as part of the initial
implementation of UpdateableResultSet.

>
> Tried variations with TYPE_SCROLL_INSENSITIVE and CONCUR_UPDATABLE, but
> got the same error.
>
> Checked the www.retep.org.uk site.  It said Peter is working on
> scrollable result sets.

I've not had chance to update it since the domain moved.

>
> Hence I jumped to the conclusion that scrollable result sets (sensitive
> or insensitive) were not supported.

I actually found the other week loads of minor methods that were reporting this
when they shouldn't have.

Peter

>
> Thanks and regards
> Ram
>
>



--
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/