Derby
  1. Derby
  2. DERBY-208

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

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Major 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.

      1. LOBLocator.pdf
        1.17 MB
        Fernanda Pizzorno
      2. LOBLocatorv2.pdf
        121 kB
        Øystein Grøvlen
      3. releaseNote.html
        5 kB
        Rick Hillegas
      4. releaseNote.html
        5 kB
        Rick Hillegas
      5. releaseNote.html
        5 kB
        Øystein Grøvlen
      6. releaseNote.html
        5 kB
        Øystein Grøvlen

        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

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development