Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (hermes.apache.org: domain of msatoor@gmail.com designates
 64.233.184.196 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=DgBCFxLycJCJJQfAwU9mLx9rRRXsEdG3u7vfc7fpFA2FJIqHg2sEgmpp7tIUxfZFNEDGsPr/ES3Xv5ENLymSk9pJlgpXnUmgMhouWjoSbJZii38g6vlxEvSff3F4hrobhZJVBiI2lCNln72UBjtGvkx+F/7mxCJxIQ65w+FSDx8=
Message-ID: <d9619e4a05042607532adaac60@mail.gmail.com>
Date: Tue, 26 Apr 2005 07:53:14 -0700
From: Mamta Satoor <msatoor@gmail.com>
Reply-To: Mamta Satoor <msatoor@gmail.com>
To: Derby Discussion <derby-user@db.apache.org>, Dag.Wanvik@sun.com
Subject: Re: Features? Status?
In-Reply-To: <17006.12030.506707.826151@sun.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <17006.12030.506707.826151@sun.com>

Hi,

Yes, Derby supports all the srollable methods on a scroll insensitive
resultset type.

Mamta

On 4/26/05, Dag H. Wanvik <Dag.Wanvik@sun.com> wrote:
>=20
> Hi Peter,
>=20
> > Which ResultSet types does derby support (TYPE_FORWARD_ONLY,
> > TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE)?
>=20
> I just looked at this and it seems this is the present state:
>=20
>             FORWARD_ONLY        SCROLLABLE_INSENSITIVE SCROLLABLE_SENSITI=
VE
>             -------------------------------------------------------------=
--
> READ_ONLY    |  OK                        OK                  No
> UPDATABLE    |  in working       [Not allowed in SQL-99]      No
>   Update    |  DERBY-99
>   Delete    |  DERBY-98
>   Insert    |  DERBY-100
>=20
> Patches for JIRA issues DERBY-99 and DERBY-98 are included on head of
> the development trunk. Over on the dev list, there is a proposal to
> start looking at adding support for updatable, scrollable result sets
> (sensitive).
>=20
> > Are all the methods for scrolling supported (previous(), afterLast(),
> > getRow() etc.)?
>=20
> As for the methods, my impression is "yes", but I didn't look at that
> in detail yet, maybe someone else can confirm it?
>=20
> Thanks,
>=20
> Dag
>