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
  3. DERBY-2496

Implement Blob support for Locators

    XMLWordPrintableJSON

Details

    Description

      DERBY-2347 adds the possibility to send locators between client and server instead of LOB values. This has not been activated yet, since the client implementation does not currently support locators. This report is for supporting the locators for Blob objects. Another JIRA issue will be made for Clob.

      This work will be made in several steps:
      1. Blob methods and ResultSet.getXXX methods
      2. PreparedStatement and CallableStatement methods
      3. ResultSet.updateXXX methods
      4. Connection.createBlob()

      There is dependencies between these steps and it might be that the Locator implementation cannot be exposed until everything has been done. At least, doing just step 1, gives testing errors because tests use Blobs fetched from DB as parameters to prepared statements. I would guess tests for updatable result sets, needs the combination of 1. and 3.

      Attachments

        1. blob_v2.diff
          29 kB
          Oystein Grovlen
        2. blob.diff
          29 kB
          Oystein Grovlen
        3. blob-followup_v2.diff
          14 kB
          Oystein Grovlen
        4. blob-followup_v2.diff
          14 kB
          Oystein Grovlen
        5. blob-followup.diff
          13 kB
          Oystein Grovlen
        6. blobtestfix.diff
          12 kB
          Oystein Grovlen
        7. enableblobloc.diff
          16 kB
          Oystein Grovlen

        Issue Links

          blocks

          Sub-task - The sub-task of the issue DERBY-2506 Adding the locator information to FD:OCA descriptor (FDODSC) andFD:OCA data (FDODTA) of the SQLDTA objects

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue DERBY-2587 Connection.createClob() and Connection.createBlob() need to return locator support enabled LOB objects in the NetworkClient

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue DERBY-2702 Enable Clob locator support between NetworkServer and NetworkClient and modify tests that experience changed behaviour due to this(enabling Clob Locators).

          • Major - Major loss of function.
          • Closed
          is part of

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-208 Add support to retrieve lobs for Network Server by locator rather than matierializing the LOB

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

          Bug - A problem which impairs or prevents the functions of the product. DERBY-6923 Passing a ClientClob or ClientBlob from another connection to an INSERT statement results in 'null' being written.

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

          Activity

            People

              oysteing Oystein Grovlen
              oysteing Oystein Grovlen
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: