[ http://nagoya.apache.org/jira/browse/DERBY-66?page=comments#action_56082 ] Mamta A. Satoor commented on DERBY-66: --------------------------------------
IMO, open cursors across commits and holding cursors across commits mean one and the same thing for Derby. But what is unclear to me is the description of return value of DatabaseMetaData.supportsOpenCursorsAcrossCommit in the JDBC api. The JDBC api says following boolean supportsOpenCursorsAcrossCommit() throws SQLExceptionRetrieves whether this database supports keeping cursors open across commits. Returns: true if cursors always remain open; false if they might not remain open Throws: SQLException - if a database access error occurs A ResultSet object maintains a cursor pointing to its current row of data. Derby will keep the cursor open across commit if the ResultSet object's holdability is set to HOLD_CURSORS_OVER_COMMIT. If the ResultSet object's holdability is set to CLOSE_CURSORS_AT_COMMIT, the cursor will be closed when the transaction is committed. So, in Derby, whether a cursor stays open or closed across commit depends on the holdability of the ResultSet object. Does it then mean from the above api description that supportsOpenCursorsAcrossCommit() should return false in Derby? If that is the conclusion, then there is no bug with current implementation of supportsOpenCursorsAcrossCommit(). > Derby supports open cursor across commits and hence > DatabaseMetaData.supportsOpenCursorsAcrossCommit return true. > ----------------------------------------------------------------------------------------------------------------- > > Key: DERBY-66 > URL: http://nagoya.apache.org/jira/browse/DERBY-66 > Project: Derby > Type: Bug > Components: JDBC > Versions: 10.0.2.0 > Reporter: Mamta A. Satoor > Priority: Minor > > Derby returns false for DatabaseMetaData.supportsOpenCursorsAcrossCommit. But > that seems incorrect because Derby does support open cursor across commits > and hence DatabaseMetaData.supportsOpenCursorsAcrossCommit return true. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://nagoya.apache.org/jira/secure/Administrators.jspa - If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
