Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-310 Document and/or change Derby client code to match behavior with Embedded driver where possible.
  3. DERBY-370

Document differences between Embedded and Network Server for Updatable ResultSets functionality

    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.1.1.0
    • Fix Version/s: 10.1.1.0
    • Component/s: Documentation
    • Labels:
      None

      Description

      The functionality of updatable resultset for Network Server is similar to what Embedded Derby supports, with the exception of following differences
      1)DNC requires that there be at least one column in the select list from the target table.
      eg select 1, 2 from t1 for update of c11 will fail in Network Server because driver looks at both the columns in the select list and it can't determine the target table for update/delete looking at those columns' metadata. This is not required by embedded driver. There is test for this (Positive Test2 in updatableResultSet.java).
      2)Embedded driver allows Statement name change when there is an open resultset on that statement object. DNC driver does not supported that. (Positive Test8a and Test8b in updatableResultSet.java )
      3)(Positive Test20) Embedded driver allows updateString on SMALLINT, INTEGER, BIGINT, DECIMAL datatypes. DNC doesn't.
      Embedded driver support updateBytes on CHAR, VARCHAR, LONG VARCHAR datatypes. DNC doesn't
      Embedded driver support updateTime on TIMESTAMP datatypes. DNC doesn't
      Embedded driver supports updateObject with null value. DNC doesn't
      DNC does not support updateClob and updateBlob

        Attachments

        1. derby370revised.zip
          5 kB
          Jeff Levitt

          Activity

            People

            • Assignee:
              jlevitt Jeff Levitt
              Reporter:
              mamtas Mamta A. Satoor
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: