[
https://issues.apache.org/jira/browse/DERBY-1769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dag H. Wanvik reopened DERBY-1769:
----------------------------------
merge to 10.3 branch
> Add mention that Derby supports rowUpdated, rowDeleted with a result set
> concurrency of CONCUR_READ_ONLY
> ---------------------------------------------------------------------------------------------------------
>
> Key: DERBY-1769
> URL: https://issues.apache.org/jira/browse/DERBY-1769
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.2.1.6, 10.2.2.0, 10.3.1.4
> Reporter: Dag H. Wanvik
> Assignee: Dag H. Wanvik
> Priority: Minor
> Fix For: 10.3.1.5, 10.4.0.0
>
> Attachments: DERBY-1769.diff, DERBY-1769.stat, DERBY-1769.zip
>
>
> We should add a note on the behavior on the rowXXX methods in
> java.sql.ResultSet, since they now (as of JDBC 4.0) have an optional
> feature.
> Cf this "Note:" for rowDeleted in JDBC4 API:
> > boolean rowDeleted() throws SQLException
> >
> > Retrieves whether a row has been deleted. A deleted row may leave a
> > visible "hole" in a result set. This method can be used to detect
> > holes in a result set. The value returned depends on whether or not
> > this ResultSet object can detect deletions.
> >
> > Note: Support for the rowDeleted method is optional with a result set
> > concurrency of CONCUR_READ_ONLY
> >
> > Returns:
> > true if the current row is detected to have been deleted
> > by the owner or another; false otherwise
> > Throws:
> > SQLException - if a database access error occurs or this
> > method is called on a closed result set
> >
> > SQLFeatureNotSupportedException - if the JDBC driver does
> > not support this method
> > Since:
> > 1.2
> > See Also:
> > DatabaseMetaData.deletesAreDetected(int)
> For updatable result sets, Derby supports calling the methods
> rowDeleted, rowUpdated and rowInserted even if the RS had concurrency
> CONCUR_READ_ONLY. If the query's underlying result set if scrollable
> and updatable, rowUpdated and rowDeleted can be used to detect if
> changes were made using positioned UPDATE/DELETEs, since positioned
> modifications are seen by the result set in Derby. Normally, though,
> such usage is not recommended. If updates are required, the RS should
> have concurrency CONCUR_UPDATABLE.
> rowInserted will always return false, since Derby does not detect
> inserts.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
