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

Add scrollable, updatable, insensitive result sets

    XMLWordPrintableJSON

    Details

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

      Description

      JDBC result sets are created with three properties: type, concurrency
      and holdability. The type can be one of TYPE_FORWARD_ONLY,
      TYPE_SCROLL_INSENSITIVE and TYPE_SCROLL_SENSITIVE. The concurrency can
      be one of CONCUR_READ_ONLY and CONCUR_UPDATABLE. The holdability can
      be one of HOLD_CURSORS_OVER_COMMIT and CLOSE_CURSORS_AT_COMMIT.

      JDBC allows the full cross product of these. SQL 2003 prohibits the
      combination

      {TYPE_SCROLL_INSENSITIVE, CONCUR_UPDATABLE}

      , but this
      combination is supported by some vendors, notably Oracle.

      Currently, Derby supports JDBC result sets in a limited
      way. Holdability is supported. Furthermore, the following is
      supported:

      • forward-only, read-only
      • forward-only, updatable (update, delete, but not insert)
        Also, in the network driver, support for some data types
        conversions is missing.
      • scroll insensitive, read-only

      We (Fernanda and Andreas will cooperate with me on this) propose a
      plan to add support for the combination:

      • scroll insensitive, updatable

      for both the embedded driver and the network client driver.
      As a part of this we would also like to add the missing insert
      operation to the

      {forward-only, updatable}

      result sets (JIRA-100), and
      remove the requirement for an explicit "FOR UPDATE" clause in the SQL
      query to achieve updatability if CONCUR_UPDATABLE is specified
      (JIRA-231).

      The full proposal text is uploaded as an attachment, including a proposed
      functional specification.

      This JIRA will be used to track sub-issues for this effort. The sub-issues will be linked back to this issue.

        Attachments

        1. derby-690-v8.stat
          3 kB
          Fernanda Pizzorno
        2. derby-690-v8.diff
          125 kB
          Fernanda Pizzorno
        3. derby-690-v7.stat
          3 kB
          Fernanda Pizzorno
        4. derby-690-v7.diff
          125 kB
          Fernanda Pizzorno
        5. derby-690-v6.diff
          126 kB
          Fernanda Pizzorno
        6. derby-690-v6.stat
          3 kB
          Fernanda Pizzorno
        7. derby-690-v5.stat
          3 kB
          Fernanda Pizzorno
        8. derby-690-v5.diff
          128 kB
          Fernanda Pizzorno
        9. derby-690-v4.diff
          127 kB
          Fernanda Pizzorno
        10. derby-690-v4.stat
          3 kB
          Fernanda Pizzorno
        11. writeup-v4.html
          22 kB
          Fernanda Pizzorno
        12. writeup-v3.html
          21 kB
          Dag H. Wanvik
        13. DERBY-690-v2.diff
          129 kB
          Fernanda Pizzorno
        14. DERBY-690-v2.stat
          3 kB
          Fernanda Pizzorno
        15. writeup-v2.html
          19 kB
          Fernanda Pizzorno
        16. DERBY-690-v1.stat
          3 kB
          Fernanda Pizzorno
        17. DERBY-690-v1.diff
          129 kB
          Fernanda Pizzorno
        18. SURChanges-v1.pdf
          28 kB
          Andreas Korneliussen
        19. writeup-v1.html
          18 kB
          Andreas Korneliussen
        20. sur-proposal.txt
          16 kB
          Dag H. Wanvik

          Issue Links

          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                dagw Dag H. Wanvik
                Reporter:
                dagw Dag H. Wanvik
              • Votes:
                1 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: