[DERBY-255] Closing a resultset after retrieving a large > 32K value with Network Server does not release locks

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.1.1.0
• Fix Version/s: 10.1.1.0
• Component/s: Network Server
• Assignee: Katherine Marsden
• Reporter: Katherine Marsden
• Created: 01/May/05 14:14
• Updated: 06/Jul/07 15:59
• Resolved: 02/Jun/05 18:30

Description

Closing a resultset after retriving BLOB or CLOB data > 32K, does not release locks properly. Network Server uses getClob, getBlob to retrieve the data even if the application uses getCharacteStream, etc, so holds locks to the end of the transaction.

To reproduce run attached repro
java LargeDataLocks derbynetclient

To see the difference with embedded
java LargeDataLocks derby

Issue Links

• relates to: DERBY-2892 Closing a resultset after retrieving a large > 32665 bytes value with Network Server does not release locks