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

Add scrollable, updatable, insensitive result sets

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 10.2.1.6
    • JDBC
    • 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-v1.diff
          129 kB
          Fernanda Pizzorno
        2. DERBY-690-v1.stat
          3 kB
          Fernanda Pizzorno
        3. DERBY-690-v2.diff
          129 kB
          Fernanda Pizzorno
        4. DERBY-690-v2.stat
          3 kB
          Fernanda Pizzorno
        5. derby-690-v4.diff
          127 kB
          Fernanda Pizzorno
        6. derby-690-v4.stat
          3 kB
          Fernanda Pizzorno
        7. derby-690-v5.diff
          128 kB
          Fernanda Pizzorno
        8. derby-690-v5.stat
          3 kB
          Fernanda Pizzorno
        9. derby-690-v6.diff
          126 kB
          Fernanda Pizzorno
        10. derby-690-v6.stat
          3 kB
          Fernanda Pizzorno
        11. derby-690-v7.diff
          125 kB
          Fernanda Pizzorno
        12. derby-690-v7.stat
          3 kB
          Fernanda Pizzorno
        13. derby-690-v8.diff
          125 kB
          Fernanda Pizzorno
        14. derby-690-v8.stat
          3 kB
          Fernanda Pizzorno
        15. SURChanges-v1.pdf
          28 kB
          Andreas Korneliussen
        16. sur-proposal.txt
          16 kB
          Dag H. Wanvik
        17. writeup-v1.html
          18 kB
          Andreas Korneliussen
        18. writeup-v2.html
          19 kB
          Fernanda Pizzorno
        19. writeup-v3.html
          21 kB
          Dag H. Wanvik
        20. writeup-v4.html
          22 kB
          Fernanda Pizzorno

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: