Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-208

Add support to retrieve lobs for Network Server by locator rather than matierializing the LOB

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.1.1.0
    • 10.3.1.4
    • Network Server
    • None
    • Release Note Needed

    Description

      Currently Network Server materializes all LOB objects. LOB locator support is part of the DRDA spec so could be added to network server. See
      http://www.opengroup.org/dbiop/

      It is not clear if SQL Support for LOB locators would also be required.

      Attachments

        1. LOBLocator.pdf
          1.17 MB
          Fernanda Pizzorno
        2. LOBLocatorv2.pdf
          121 kB
          Oystein Grovlen
        3. releaseNote.html
          5 kB
          Richard N. Hillegas
        4. releaseNote.html
          5 kB
          Richard N. Hillegas
        5. releaseNote.html
          5 kB
          Oystein Grovlen
        6. releaseNote.html
          5 kB
          Oystein Grovlen

        Issue Links

          incorporates

          Sub-task - The sub-task of the issue DERBY-2496 Implement Blob support for Locators

          • Major - Major loss of function.
          • Closed
          is related to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2781 10.2 client blobclob4blob test run against 10.3 server fails for many tests with SQLSTATE(XJ073): The data in this BLOB or CLOB is no longer available.

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-1560 When receiving EXTDTA object, the client should avoid keeping the entire LOB in memory for large LOBs

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-2892 Closing a resultset after retrieving a large > 32665 bytes value with Network Server does not release locks

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4312 SQLException XJ215 on insert with setCharacterStream() and autocommit off in mailjdbc test

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-2807 Create a test for BlobClob compatibility on Derby server versions vs. Derby client versions.

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed
          There are no Sub-Tasks for this issue.

          Activity

            People

              Unassigned Unassigned
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: