db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamta A. Satoor (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-66) Derby supports open cursor across commits and hence DatabaseMetaData.supportsOpenCursorsAcrossCommit return true.
Date Thu, 02 Dec 2004 06:30:24 GMT
     [ 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


Mime
View raw message