[ https://issues.apache.org/jira/browse/DERBY-6761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen closed DERBY-6761. ------------------------------------- Resolution: Not a Problem Thanks. Closing the issue as not a problem. > Closing resultset after retrieving a large > 32k value lob does not release > locks > --------------------------------------------------------------------------------- > > Key: DERBY-6761 > URL: https://issues.apache.org/jira/browse/DERBY-6761 > Project: Derby > Issue Type: Bug > Components: Network Server > Affects Versions: 10.10.2.0, 10.11.1.1 > Environment: Windows 8.1, Windows 7, jdk 8 > Reporter: Karl Griesser > Priority: Critical > Attachments: Main.java > > > Same issue as in https://issues.apache.org/jira/browse/DERBY-2892 but seems > to have made it into 10.0.2.0 > I've create a simple java that > *) creates a database + table. > *) inserts data (first round 10k blob) > *) select with close rs and close statement > *) prints locks > *) inserts data (first round > 32k blob) > *) select with close rs and close statement > *) prints locks > In the scenario with the 32k blob the Shared Lock on the row is not released > until the transaction is commited. -- This message was sent by Atlassian JIRA (v6.3.4#6332)