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

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.1.0
    • Fix Version/s: 10.3.1.4
    • Component/s: Network Server
    • Labels:
      None
    • Issue & fix info:
      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. releaseNote.html
          5 kB
          Rick Hillegas
        2. releaseNote.html
          5 kB
          Rick Hillegas
        3. releaseNote.html
          5 kB
          Øystein Grøvlen
        4. releaseNote.html
          5 kB
          Øystein Grøvlen
        5. LOBLocatorv2.pdf
          121 kB
          Øystein Grøvlen
        6. LOBLocator.pdf
          1.17 MB
          Fernanda Pizzorno

          Issue Links

          1.
          Implementing the stored procedures called by the LOB related JDBC methods Sub-task Closed V.Narayanan
          2.
          Add code to support request and return of locators over DRDA Sub-task Closed Øystein Grøvlen
          3.
          Create framework for calling locator related stored procedures from client Sub-task Closed Øystein Grøvlen
          4.
          Implement Blob support for Locators Sub-task Closed Øystein Grøvlen
          5.
          Adding the locator information to FD:OCA descriptor (FDODSC) andFD:OCA data (FDODTA) of the SQLDTA objects Sub-task Closed V.Narayanan
          6.
          Client PreparedStatement/CallableStatement implementations need to use locators Sub-task Closed V.Narayanan
          7.
          Restructure code for Blob/Clob length in client to prepare for locator implementation Sub-task Closed Øystein Grøvlen
          8.
          BrokeredConnection needs to forward implementations of locator related methods in EngineConnection to the underlying physical connection Sub-task Closed V.Narayanan
          9.
          Connection.createClob() and Connection.createBlob() need to return locator support enabled LOB objects in the NetworkClient Sub-task Closed V.Narayanan
          10.
          Remove temporary code added to enable testing of CLOB locator related stored procedures. Sub-task Closed V.Narayanan
          11.
          Implement Clob support for locators Sub-task Closed V.Narayanan
          12.
          Fix javadoc issues related to locator work Sub-task Closed V.Narayanan
          13.
          Fix build problems related to locator work Sub-task Closed V.Narayanan
          14.
          Add locator support of soft upgrade to 10.3 Sub-task Closed Øystein Grøvlen
          15.
          Enable Clob locator support between NetworkServer and NetworkClient and modify tests that experience changed behaviour due to this(enabling Clob Locators). Sub-task Closed V.Narayanan

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                kmarsden Kathey Marsden
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: