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. releaseNote.html
        5 kB
        Øystein Grøvlen
      2. releaseNote.html
        5 kB
        Øystein Grøvlen
      3. releaseNote.html
        5 kB
        Rick Hillegas
      4. releaseNote.html
        5 kB
        Rick Hillegas
      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

          Kathey Marsden created issue -
          Bryan Pendleton made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-1560 [ DERBY-1560 ]
          Fernanda Pizzorno made changes -
          Attachment LOBLocator.pdf [ 12347382 ]
          Øystein Grøvlen made changes -
          Attachment LOBLocatorv2.pdf [ 12351890 ]
          Øystein Grøvlen made changes -
          Fix Version/s 10.3.0.0 [ 12310800 ]
          Derby Info [Existing Application Impact, Release Note Needed]
          Myrna van Lunteren made changes -
          Link This issue is related to DERBY-2781 [ DERBY-2781 ]
          Ole Solberg made changes -
          Link This issue relates to DERBY-2807 [ DERBY-2807 ]
          Øystein Grøvlen made changes -
          Attachment releaseNote.html [ 12359712 ]
          Øystein Grøvlen made changes -
          Attachment releaseNote.html [ 12359829 ]
          Rick Hillegas made changes -
          Attachment releaseNote.html [ 12359939 ]
          Rick Hillegas made changes -
          Attachment releaseNote.html [ 12359940 ]
          Myrna van Lunteren made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Resolved [ 5 ]
          Derby Info [Release Note Needed, Existing Application Impact] [Existing Application Impact, Release Note Needed]
          Myrna van Lunteren made changes -
          Link This issue incorporates DERBY-2496 [ DERBY-2496 ]
          Tomohito Nakayama made changes -
          Link This issue relates to DERBY-2892 [ DERBY-2892 ]
          Kathey Marsden made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Dag H. Wanvik made changes -
          Issue & fix info [Release Note Needed, Existing Application Impact] [Release Note Needed]
          Dag H. Wanvik made changes -
          Issue Type New Feature [ 2 ] Improvement [ 4 ]
          Kathey Marsden made changes -
          Link This issue relates to DERBY-4312 [ DERBY-4312 ]
          Gavin made changes -
          Workflow jira [ 41588 ] Default workflow, editable Closed status [ 12801288 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development