db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "TenTwoSnapshot" by DagWanvik
Date Mon, 29 May 2006 17:01:35 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by DagWanvik:
http://wiki.apache.org/db-derby/TenTwoSnapshot

------------------------------------------------------------------------------
  ||Implicit closing||The JDBC4 spec clarifies that insensitive, scrollable result sets should
not close implicitly when scrolled past the last row. Derby's embedded client violates this
contract.||NOT compliant.||
  ||Procedure invocation||The JDBC4 spec clarifies that stored procedures can be invoked by
Statement.executeQuery(). Derby does not support this usage yet.||NOT compliant.||
  
- == SUR Status ==
+ == Scrollable, Updatable ResultSets (Insensitive) Status ==
  
- Hey, Dag, could you fill this in?
+ This feature has been fully implemented for both embedded (compliant) and network client
(compliant, but see note below) drivers. Documentation is still pending. Highlights of this
feature:
+ 
+  * It extends Derby's existing scrollable insensitive result sets to be updatable via both
the JDBC provided methods ''updateRow'', ''deleteRow'' and ''insertRow'', as well as positioned
DELETE and UPDATE statements.
+ 
+  * Own deletes and updates are visible, inserts are not.  Deleted rows leave "holes". The
detectability methods ''rowDeleted'' and ''rowUpdated'' are supported.
+ 
+  * Main JIRA issues: [http://issues.apache.org/jira/browse/DERBY-690 DERBY-690], [http://issues.apache.org/jira/browse/DERBY-775
DERBY-775] and [http://issues.apache.org/jira/browse/DERBY-717 DERBY-717].
+ 
+ '''Note''': With the client driver, lobs are not supported for scrollable result sets, whether
read-only or updatable.
+ 
+ As part of this effort, we also:
+ 
+  * lifted the "FOR UPDATE" clause requirement for a SQL query to be updatable via result
sets methods ([http://issues.apache.org/jira/browse/DERBY-231 DERBY-231]).
+ 
+  * implemented ''insertRow'' for forward-only updatable result sets ([http://issues.apache.org/jira/browse/DERBY-100
DERBY-100]).
+ 
  
  == Grant/Revoke Status ==
  

Mime
View raw message