Derby
  1. Derby
  2. DERBY-4491

The network client changes UDTs into Strings and returns their type as LONGVARBINARY.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.2.1, 10.1.3.1, 10.2.1.6, 10.2.2.0, 10.3.1.4, 10.3.2.1, 10.3.3.0, 10.4.1.3, 10.4.2.0, 10.5.1.1, 10.5.2.0, 10.5.3.0
    • Fix Version/s: 10.6.1.0
    • Component/s: JDBC
    • Issue & fix info:
      Patch Available
    • Bug behavior facts:
      Embedded/Client difference

      Description

      This is a pre-existing bug which seems to have been with Derby since the beginning. Some of the columns in the system tables (e.g., SYS.SYSALIASES.ALIASINFO) contain objects. If you select these columns:

      1) In the embedded client you will get the correct results. You will get the objects in these columns. In addition, the ResultSetMetaData for these columns will correctly report that the columns have type JAVA_OBJECT and will give a reasonable type name (the class name for the object in the column).

      2) However, in the network client, you will get the wrong results. ResultSet.getObject() will return Strings rather than the original objects. In addition, the ResultSetMetaData for these columns will incorrectly report that their type is LONGVARBINARY.

      1. derby-4491-02-aa-supportsUDTs.diff
        0.5 kB
        Kristian Waagan
      2. derby-4491-01-ad-networkTransport.diff
        96 kB
        Rick Hillegas
      3. derby-4491-01-ab-networkTransport.diff
        74 kB
        Rick Hillegas

        Issue Links

          Activity

          Rick Hillegas created issue -
          Rick Hillegas made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-651 [ DERBY-651 ]
          Rick Hillegas made changes -
          Summary The network client changes UDTs into Strings and returns that their type is LONGVARBINARY. The network client changes UDTs into Strings and returns their type is LONGVARBINARY.
          Bug behavior facts [Embedded/Client difference]
          Rick Hillegas made changes -
          Summary The network client changes UDTs into Strings and returns their type is LONGVARBINARY. The network client changes UDTs into Strings and returns their type as LONGVARBINARY.
          Rick Hillegas made changes -
          Link This issue is related to DERBY-4499 [ DERBY-4499 ]
          Rick Hillegas made changes -
          Attachment derby-4491-01-ab-networkTransport.diff [ 12429256 ]
          Rick Hillegas made changes -
          Assignee Rick Hillegas [ rhillegas ]
          Rick Hillegas made changes -
          Issue & fix info [Patch Available]
          Rick Hillegas made changes -
          Attachment derby-4491-01-ad-networkTransport.diff [ 12429853 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-4516 [ DERBY-4516 ]
          Rick Hillegas made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Kristian Waagan made changes -
          Resolution Fixed [ 1 ]
          Status Resolved [ 5 ] Reopened [ 4 ]
          Kristian Waagan made changes -
          Attachment derby-4491-02-aa-supportsUDTs.diff [ 12437617 ]
          Kristian Waagan made changes -
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Rick Hillegas made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Rick Hillegas made changes -
          Link This issue is related to DERBY-4688 [ DERBY-4688 ]
          Rick Hillegas made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kathey Marsden made changes -
          Status Closed [ 6 ] Reopened [ 4 ]
          Resolution Fixed [ 1 ]
          Kathey Marsden made changes -
          Labels derby_backport_reject_10_5
          Kathey Marsden made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Gavin made changes -
          Workflow jira [ 12485378 ] Default workflow, editable Closed status [ 12800956 ]

            People

            • Assignee:
              Rick Hillegas
              Reporter:
              Rick Hillegas
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development