Derby
  1. Derby
  2. DERBY-1938

Add support for setObject(<arg>, null)

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.7.1.1
    • Component/s: JDBC
    • Labels:
      None

      Description

      Derby presently does not implement support for the method
      PreparedStatement.setObject (and similarly for CallableStatement.setObject)
      when the supplied value is null, unless a type argument (3rd arg) is also present.
      That is, in:
      void setObject(int parameterIndex,
      Object x)
      throws SQLException
      x can not be null.

      Derby will presently throw an SQLException (client: XJ021, embedded: 22005)
      if x is null when calling this method on a preparedStatement.

      Porting some applications may be made easier if this restriction is lifted.
      See also discussion in DERBY-1904.

      1. DERBY-1938.patch
        117 kB
        Tomohito Nakayama
      2. derby-1938-1a-reworked_patch.diff
        4 kB
        Kristian Waagan
      3. derby-1938-1b-reworked_patch.diff
        6 kB
        Kristian Waagan

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12386327 ] Default workflow, editable Closed status [ 12801471 ]
          Dag H. Wanvik made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Rick Hillegas made changes -
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Kristian Waagan made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Assignee Kristian Waagan [ kristwaa ]
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Resolution Fixed [ 1 ]
          Kristian Waagan made changes -
          Attachment derby-1938-1b-reworked_patch.diff [ 12454096 ]
          Kristian Waagan made changes -
          Attachment derby-1938-1a-reworked_patch.diff [ 12454011 ]
          Kathey Marsden made changes -
          Assignee Tomohito Nakayama [ naka ]
          Kristian Waagan made changes -
          Derby Info [Patch Available]
          Tomohito Nakayama made changes -
          Derby Info [Patch Available]
          Tomohito Nakayama made changes -
          Attachment DERBY-1938.patch [ 12342574 ]
          Tomohito Nakayama made changes -
          Link This issue relates to DERBY-1610 [ DERBY-1610 ]
          Tomohito Nakayama made changes -
          Assignee Tomohito Nakayama [ naka ]
          Dag H. Wanvik made changes -
          Summary Add support for setObject(<col>, null) Add support for setObject(<arg>, null)
          Dag H. Wanvik made changes -
          Field Original Value New Value
          Link This issue is related to DERBY-1904 [ DERBY-1904 ]
          Dag H. Wanvik created issue -

            People

            • Assignee:
              Kristian Waagan
              Reporter:
              Dag H. Wanvik
            • Votes:
              2 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development