You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Kristian Waagan (JIRA)" <ji...@apache.org> on 2011/06/01 12:49:47 UTC

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

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

                 Key: DERBY-5257
                 URL: https://issues.apache.org/jira/browse/DERBY-5257
             Project: Derby
          Issue Type: Improvement
          Components: Tools
    Affects Versions: 10.9.0.0
            Reporter: Kristian Waagan


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.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira