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 "Kathey Marsden (JIRA)" <ji...@apache.org> on 2007/04/02 23:23:32 UTC

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

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.

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

Posted by "Øystein Grøvlen (JIRA)" <ji...@apache.org>.

    [ 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.