Derby
  1. Derby
  2. DERBY-6089

CallableStatement#registerOutParameter on client lacks check of legal types.

    Details

    • Issue & fix info:
      Repro attached
    • Bug behavior facts:
      Deviation from standard

      Description

      Cf the attached negative test in a patch to PreparedStatement42.

      In JDBC 4.2, the Javadoc for registerOutParameter(int parameterIndex,
      int sqlType, String typeName) reads:

      :
      @exception SQLFeatureNotSupportedException if sqlType is a ARRAY,
      BLOB, CLOB, DATALINK, JAVA_OBJECT, NCHAR, NCLOB, NVARCHAR,
      LONGNVARCHAR, REF, ROWID, SQLXML or STRUCT data type and the JDBC
      driver does not support this data type
      :

      For the new overloads, for embedded this is checked inside Util42#getTypeAsInt. The similar
      client method, Utils42#getTypeAsInt does not do this checking.

      1. derby-6089-02-ab-addCheckToOldOverloads.diff
        95 kB
        Rick Hillegas
      2. derby-6089-02-aa-addCheckToOldOverloads.diff
        16 kB
        Rick Hillegas
      3. derby-6089-01-ab-addCheckToClient.diff
        12 kB
        Rick Hillegas
      4. derby-6089-01-aa-addCheckToClient.diff
        12 kB
        Rick Hillegas
      5. 6089-repro-old-overloads.diff
        2 kB
        Dag H. Wanvik
      6. 6089-repro.diff
        1 kB
        Dag H. Wanvik

        Issue Links

          Activity

            People

            • Assignee:
              Rick Hillegas
              Reporter:
              Dag H. Wanvik
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development