db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-690) Add scrollable, updatable, insensitive result sets
Date Thu, 23 Mar 2006 13:24:43 GMT
As far as I can tell, this one is now properly reviewed and ready for
commit. It is a rather large patch and there has been a lot of
discussion so I plan to commit this on monday if there are no
objections.


>>>>>>>>>>>> Fernanda Pizzorno (JIRA) wrote (2006-03-23
13:02:14):
>     [ http://issues.apache.org/jira/browse/DERBY-690?page=comments#action_12371555 ]

> 
> Fernanda Pizzorno commented on DERBY-690:
> -----------------------------------------
> 
> The patch has been reveiewed and all comments have been addressed. Can someone please
commit this patch?
> 
> Thank you in advance!
> 
> > 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, DERBY-690-v2.stat,
SURChanges-v1.pdf, 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, sur-proposal.txt,
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
> 

-- 
Bernt Marius Johnsen, Database Technology Group, 
Staff Engineer, Technical Lead Derby/Java DB
Sun Microsystems, Trondheim, Norway

Mime
View raw message