db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-690) Add scrollable, updatable, insensitive result sets
Date Fri, 15 Sep 2006 15:26:24 GMT
     [ http://issues.apache.org/jira/browse/DERBY-690?page=all ]

Rick Hillegas updated DERBY-690:
--------------------------------

    Derby Info: [Patch Available]  (was: [Patch Available, Release Note Needed])

Toggling off the "release note needed" flag since I'm already tracking this for the Release
Notes and expect to cull a description from the 10.2 snapshot wiki.

> Add scrollable, updatable, insensitive result sets
> --------------------------------------------------
>
>                 Key: DERBY-690
>                 URL: http://issues.apache.org/jira/browse/DERBY-690
>             Project: Derby
>          Issue Type: New Feature
>          Components: JDBC
>            Reporter: Dag H. Wanvik
>         Assigned To: Dag H. Wanvik
>            Priority: Minor
>             Fix For: 10.2.1.0
>
>         Attachments: DERBY-690-v1.diff, DERBY-690-v1.stat, DERBY-690-v2.diff, DERBY-690-v2.stat,
derby-690-v4.diff, derby-690-v4.stat, derby-690-v5.diff, derby-690-v5.stat, derby-690-v6.diff,
derby-690-v6.stat, derby-690-v7.diff, derby-690-v7.stat, derby-690-v8.diff, derby-690-v8.stat,
sur-proposal.txt, SURChanges-v1.pdf, writeup-v1.html, writeup-v2.html, writeup-v3.html, writeup-v4.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: 
> 	   - forward-only, read-only 
> 	   - forward-only, updatable (update, delete, but not insert)
> 	     Also, in the network driver, support for some data types
> 	     conversions is missing.
> 	   - scroll insensitive, read-only
> We (Fernanda and Andreas will cooperate with me on this) propose a
> plan to add support for the combination:
> 	   - scroll insensitive, updatable
> for both the embedded driver and the network client driver. 
> 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-issues will be linked
back to this issue.

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

        

Mime
View raw message