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

          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.
          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.

            People

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

              Dates

              • Created:
                Updated:

                Development