You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Øystein Grøvlen (JIRA)" <ji...@apache.org> on 2007/04/02 23:53:32 UTC

[jira] Commented: (DERBY-2510) Network server does not release locks on commit and getMoreResults if multiple resultsets are returned by a stored procedure

    [ https://issues.apache.org/jira/browse/DERBY-2510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12486146 ] 

Øystein Grøvlen commented on DERBY-2510:
----------------------------------------

What kind of locks are we talking about here?  I would assume that network server has no responsibility for releasing row locks and table locks.  Such locks are released on transaction commit.  Could the problem be that commit is not done?


> Network server does not release locks on commit and getMoreResults  if multiple resultsets are returned by a stored procedure
> -----------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2510
>                 URL: https://issues.apache.org/jira/browse/DERBY-2510
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client, Network Server
>    Affects Versions: 10.3.0.0
>            Reporter: Kathey Marsden
>            Priority: Minor
>
> In converting the procedure.java tests I found that locks were not being released properly after commit and getMoreResults().  See comment at  https://issues.apache.org/jira/browse/DERBY-2461#action_12486075 for details.  The fixture checkCommitWithMultipleResultSets in the converted test LangProcedureTest will not run with Network Server until this is fixed.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.