Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Development" <derby-dev@db.apache.org>
Received-SPF: pass (hermes.apache.org: local policy)
Date: Wed, 05 Jan 2005 18:42:45 +0530
From: Shreyas Kaushik <Shreyas.Kaushik@Sun.COM>
Subject: Re: [jira] Commented: (DERBY-66) Derby supports open cursor across
 commits and hence DatabaseMetaData.supportsOpenCursorsAcrossCommit return
 true.
In-reply-to: <870660367.1103796969805.JavaMail.apache@nagoya>
To: Derby Development <derby-dev@db.apache.org>
Reply-to: Shreyas.Kaushik@Sun.COM
Message-id: <41DBE7CD.5060800@Sun.COM>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
User-Agent: Mozilla/5.0 (X11; U; SunOS sun4u; en-US; rv:1.4) Gecko/20040414
References: <870660367.1103796969805.JavaMail.apache@nagoya>

Can someone please update what is happening on this issue?

thanks
Shreyas

Shreyas Kaushik (JIRA) wrote:
>      [ http://nagoya.apache.org/jira/browse/DERBY-66?page=comments#action_57008 ]
>      
> Shreyas Kaushik commented on DERBY-66:
> --------------------------------------
> 
> I think it's the other way around. As the JDBC api says "Retrieves whether this database supports keeping cursors open across commits" it is the property of the database.
> 
> Since Derby can have cursors that are open across commits it should return true. 
> 
> To be even precise, when creating a ResultSet handle that needs to have cursors open across commits, a check on whether the underlying Database supports such a holdability has to be checked.
> 
> 
>>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.
> 
>