[DERBY-3354] Select from large lob table with embedded gives OutOfMemoryError

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.3.1.4, 10.3.2.1, 10.4.1.3
• Fix Version/s: 10.3.3.0, 10.4.1.3, 10.5.1.1
• Component/s: SQL
• Bug behavior facts: Regression
• Assignee: Anurag Aggarwal
• Reporter: Katherine Marsden
• Created: 28/Jan/08 19:50
• Updated: 30/Jun/09 15:55
• Resolved: 07/Apr/08 08:50

Description

Retrieving from a large table with lobs gives an OutOfMemoryException, even if free() is explictly called on the lob. I believe this is because EmbedConnection.addLobMapping is called for every lob creation but is never cleared until commit or rollback, even if the lob is freed.