Derby
  1. Derby
  2. DERBY-965

DatabaseMetadata method supportsResultSetConcurrency returns wrong result on network client

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor 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.

      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

          No work has yet been logged on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development