From: | "Ramachandra K(dot)B(dot)S" <ram(at)meritsystems(dot)com> |
---|---|
To: | "'Peter T Mount'" <peter(at)retep(dot)org(dot)uk>, Michael Stephenson <mstephenson(at)tirin(dot)openworld(dot)co(dot)uk> |
Cc: | "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets |
Date: | 2001-01-25 10:29:52 |
Message-ID: | D146AB5F4EE5D311B3E1004005726BB51B660F@mainserver |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Quoting Peter Mount <peter(at)retep(dot)org(dot)uk>
> Quoting Michael Stephenson <mstephenson(at)tirin(dot)openworld(dot)co(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-01-25 11:20:11 | Re: Open 7.1 items |
Previous Message | Michael Stephenson | 2001-01-25 10:25:59 | RE: Re: Postgresql JDBC driver - Support for Scrollable Re sult Sets |