From derby-dev-return-16474-apmail-db-derby-dev-archive=db.apache.org@db.apache.org Tue Mar 07 12:40:55 2006 Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 85447 invoked from network); 7 Mar 2006 12:40:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 7 Mar 2006 12:40:55 -0000 Received: (qmail 48181 invoked by uid 500); 7 Mar 2006 12:40:54 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 48145 invoked by uid 500); 7 Mar 2006 12:40:53 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 48136 invoked by uid 99); 7 Mar 2006 12:40:53 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Mar 2006 04:40:53 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [192.87.106.226] (HELO ajax) (192.87.106.226) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Mar 2006 04:40:50 -0800 Received: from ajax (localhost.localdomain [127.0.0.1]) by ajax (Postfix) with ESMTP id E60EBD49FA for ; Tue, 7 Mar 2006 12:39:39 +0000 (GMT) Message-ID: <2053239098.1141735179939.JavaMail.jira@ajax> Date: Tue, 7 Mar 2006 12:39:39 +0000 (GMT) From: =?UTF-8?Q?=C3=98ystein_Gr=C3=B8vlen_=28JIRA=29?= To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets In-Reply-To: <298084043.1131470779804.JavaMail.jira@ajax.apache.org> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/DERBY-690?page=3Dcomments#action= _12369218 ]=20 =C3=98ystein Gr=C3=B8vlen commented on DERBY-690: --------------------------------------- Some comments/questions to the write-up: * Updatability, 2nd paragraph: I think you should explain why navigations to new rows and previously fetched rows needs to be handled differently. * Isolation level read-uncommitted/read-committed, 2nd paragraph: - 1st sentence: "open" instead of "opened"? - "The result set may overwrite data in an updateRow() ... " I do not understand what you try to say here. Do you mean that updateRow may overwrite data that has been changed after the row was read by the result set? (In other words, you are talking about data in the database, not data in an updateRow.) - Last sentence: I would reformulate to say that only changed columns are written to the database on updateRow(). - Is there really anything particular about result sets in this context? Would not the same discussion be relevant for any multi-statement transaction? > Add scrollable, updatable, insensitive result sets > -------------------------------------------------- > > Key: DERBY-690 > URL: http://issues.apache.org/jira/browse/DERBY-690 > Project: Derby > Type: New Feature > Components: JDBC > Reporter: Dag H. Wanvik > Assignee: Dag H. Wanvik > Priority: Minor > Attachments: DERBY-690-v1.diff, DERBY-690-v1.stat, DERBY-690-v2.diff, DE= RBY-690-v2.stat, SURChanges-v1.pdf, sur-proposal.txt, writeup-v1.html, writ= eup-v2.html > > JDBC result sets are created with three properties: type, concurrency > and holdability. The type can be one of TYPE_FORWARD_ONLY, > TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE. The concurrency can > be one of CONCUR_READ_ONLY and CONCUR_UPDATABLE. The holdability can > be one of HOLD_CURSORS_OVER_COMMIT and CLOSE_CURSORS_AT_COMMIT. > JDBC allows the full cross product of these. SQL 2003 prohibits the > combination {TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE}, but this > combination is supported by some vendors, notably Oracle. > Currently, Derby supports JDBC result sets in a limited > way. Holdability is supported. Furthermore, the following is > supported:=20 > =09 - forward-only, read-only=20 > =09 - forward-only, updatable (update, delete, but not insert) > =09 Also, in the network driver, support for some data types > =09 conversions is missing. > =09 - scroll insensitive, read-only > We (Fernanda and Andreas will cooperate with me on this) propose a > plan to add support for the combination: > =09 - scroll insensitive, updatable > for both the embedded driver and the network client driver.=20 > As a part of this we would also like to add the missing insert > operation to the {forward-only, updatable} result sets (JIRA-100), and > remove the requirement for an explicit "FOR UPDATE" clause in the SQL > query to achieve updatability if CONCUR_UPDATABLE is specified > (JIRA-231). > The full proposal text is uploaded as an attachment, including a proposed > functional specification. > This JIRA will be used to track sub-issues for this effort. The sub-issu= es will be linked back to this issue. --=20 This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira