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

DatabaseMetadata method supportsResultSetConcurrency returns wrong result on network client

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: 10.2.1.6
    • Labels:
      None
    • Environment:
      Solaris 10, x86, Sun JDK 1.4.2

      Description

      The DatabaseMetaData method supportsResultSetConcurrency erroneously
      returns false on the network client for all arguments combination, cf
      the attached repro program. The embedded client returns correct
      results, viz the output:

      org.apache.derby.jdbc.ClientDriver:
      SupportsResultSetConcurrency: TYPE_FORWARD_ONLY,CONCUR_READ_ONLY: false
      SupportsResultSetConcurrency: TYPE_FORWARD_ONLY,CONCUR_UPDATABLE: false
      SupportsResultSetConcurrency: TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY: false
      SupportsResultSetConcurrency: TYPE_SCROLL_INSENSITIVE,CONCUR_UPDATABLE: false
      SupportsResultSetConcurrency: TYPE_SCROLL_SENSITIVE,CONCUR_READ_ONLY: false
      SupportsResultSetConcurrency: TYPE_SCROLL_SENSITIVE,CONCUR_UPDATABLE: false
      org.apache.derby.jdbc.EmbeddedDriver:
      SupportsResultSetConcurrency: TYPE_FORWARD_ONLY,CONCUR_READ_ONLY: true
      SupportsResultSetConcurrency: TYPE_FORWARD_ONLY,CONCUR_UPDATABLE: true
      SupportsResultSetConcurrency: TYPE_SCROLL_INSENSITIVE,CONCUR_READ_ONLY: true
      SupportsResultSetConcurrency: TYPE_SCROLL_INSENSITIVE,CONCUR_UPDATABLE: false
      SupportsResultSetConcurrency: TYPE_SCROLL_SENSITIVE,CONCUR_READ_ONLY: false
      SupportsResultSetConcurrency: TYPE_SCROLL_SENSITIVE,CONCUR_UPDATABLE: false

      Presumably, this is wrong in released versions as well.

        Attachments

        1. derby965b-v1.diff
          1 kB
          Dag H. Wanvik
        2. derby965b-v1.stat
          0.1 kB
          Dag H. Wanvik
        3. derby965-v2.diff
          14 kB
          Dag H. Wanvik
        4. derby965-v2.stat
          0.7 kB
          Dag H. Wanvik
        5. derby965-v1.diff
          14 kB
          Dag H. Wanvik
        6. derby965-v1.stat
          0.8 kB
          Dag H. Wanvik
        7. Main.java
          3 kB
          Dag H. Wanvik

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: