[DERBY-5257] Make ij only fetch parts of a large string/binary field when displaying it

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.9.1.0
• Component/s: Tools
• Assignee: Unassigned
• Reporter: Kristian Waagan
• Created: 01/Jun/11 10:49
• Updated: 01/Jun/11 10:50

Description

When ij displays the results of for instance 'select * from table_with_LOBs', it will fetch the whole LOBs even though it only needs a small part of the values. This will cause OOMEs unless ij is run with a sufficiently large heap.
For CLOBs, the suggested fix is to use rs.getClob().getSubString() instead of rs.getString().
The length of the substring fetched must agree with how much ij is configured to display on-screen.

Issue created based on information from DERBY-4294.

Issue Links

• is related to: DERBY-4294 java.lang.OutOfMemoryError from mailjdbc test after running for one hour from select * from REFRESH.INBOX