[DERBY-3749] in holdable cursor selecting multiple rows with streaming blobs and clobs a commit may cause later row's streams to be broken

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 10.5.1.1
• Assignee: Unassigned
• Reporter: Mike Matrigali
• Created: 01/Jul/08 21:19
• Updated: 21/Jan/11 17:52
• Resolved: 16/Jul/08 11:05

Description

In a query returning multiple rows from a table, where later rows in the select loop after the commit contain streaming clobs or blobs a commit may
attempts to get at those streams after the commit to fail with a:
3)java.sql.SQLException: The data in this BLOB or CLOB is no longer available.
The BLOB/CLOB's transaction may be committed, or its connection is closed.

Issue Links

• duplicates: DERBY-1511 SELECT clause without a WHERE, causes an Exception when extracting a Blob from a database