db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen (JIRA) <j...@apache.org>
Subject [jira] Commented: (DERBY-2510) Network server does not release locks on commit and getMoreResults if multiple resultsets are returned by a stored procedure
Date Mon, 02 Apr 2007 21:53:32 GMT

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


Mime
View raw message