Derby
  1. Derby
  2. DERBY-3377

Network Client/Server should use sqlType instead of locator value to determine if lob was sent by locator/value

    Details

    • Urgency:
      Low

      Description

      This issue came up during the fix for DERBY-3243. Currently network server does not send the correct sqlType for locators. It sends DB2_SQLTYPE_BLOB or DB2_SQLTYPE_CLOB instead of DB2_SQLTYPE_BLOB_LOCATOR or DB2_SQLTYPE_CLOB_LOCATOR so the client's only way of determining whether it is getting a lob by value or locator is to look at the locator/extended length field and use that to branch its logic. It would be cleaner moving foward to use the sqlType to branch this logic, but there would have to be version specific handling to allow it to work the old way when communicating with older versions.

      The sqlType is sent as part of the SQLDAGRP in DRDAConnThread.writeSQLDAGRP() in the
      server code.

        Issue Links

          Activity

          Kathey Marsden created issue -
          Kathey Marsden made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-3243 [ DERBY-3243 ]
          Hide
          Kathey Marsden added a comment -

          This issue came up when researching a solution for DERBY-3243. I decided for the 10.3/interim fix for DERBY-3243 to keep the current way of handling locators/values but make sure just the relevant values were excluded, since this solution won't work with older versions.

          Using the sqlType would be cleaner moving forward.

          Show
          Kathey Marsden added a comment - This issue came up when researching a solution for DERBY-3243 . I decided for the 10.3/interim fix for DERBY-3243 to keep the current way of handling locators/values but make sure just the relevant values were excluded, since this solution won't work with older versions. Using the sqlType would be cleaner moving forward.
          Kathey Marsden made changes -
          Affects Version/s 10.3.1.4 [ 12312590 ]
          Affects Version/s 10.3.2.1 [ 12312876 ]
          Affects Version/s 10.4.0.0 [ 12312540 ]
          Hide
          Tiago R. Espinha added a comment -

          Triaged for 10.5.2.

          Assigned low urgency and checked embedded/client difference as only the network server is mentioned.

          Show
          Tiago R. Espinha added a comment - Triaged for 10.5.2. Assigned low urgency and checked embedded/client difference as only the network server is mentioned.
          Tiago R. Espinha made changes -
          Bug behavior facts [Embedded/Client difference]
          Urgency Low
          Kristian Waagan made changes -
          Issue Type Bug [ 1 ] Improvement [ 4 ]
          Bug behavior facts [Embedded/Client difference]
          Labels LOB
          Kathey Marsden made changes -
          Labels LOB LOB derby_triage10_9
          Gavin made changes -
          Workflow jira [ 12422553 ] Default workflow, editable Closed status [ 12796929 ]

            People

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

              Dates

              • Created:
                Updated:

                Development