Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-1938

Add support for setObject(<arg>, null)

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: 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.

        Attachments

        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

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: