Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-946 Miscellaneous DatabaseMetaData methods added by JDBC 4
  3. DERBY-1093

Make DatabaseMetaData.getProcedures() JDBC4 compliant

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 10.2.1.6
    • 10.2.1.6
    • JDBC
    • None
    • Patch Available

    Description

      JDBC 4.0 requires that the result set returned from getProcedures must contain a new column SPECIFIC_NAME"and that the result set must be ordered by
      PROCEDURE_SCHEM, PROCEDURE_NAME and SPECIFIC_ NAME.

      The SYSALIASES table already has a column called SPECIFICNAME, so it should only be necessary to modify the query in metadata.properties.

      Attachments

        1. derby-1093.v1.diff
          22 kB
          Dyre Tjeldvoll
        2. derby-1093.v1.stat
          1.0 kB
          Dyre Tjeldvoll
        3. derby-1093.v2.diff
          19 kB
          Dyre Tjeldvoll
        4. derby-1093.v2.stat
          2 kB
          Dyre Tjeldvoll
        5. derbyall_report.txt
          1.93 MB
          Dyre Tjeldvoll
        6. derbyall_report.v2.txt
          4 kB
          Dyre Tjeldvoll
        7. upgrade.txt
          145 kB
          Dyre Tjeldvoll

        Issue Links

          blocks

          Sub-task - The sub-task of the issue DERBY-969 Update existing metadata methods in embedded client

          • Major - Major loss of function.
          • Closed
          is depended upon by

          Sub-task - The sub-task of the issue DERBY-971 Updated existing metadata methods on network client

          • Major - Major loss of function.
          • Closed
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-1243 Modify ODBCMetaDataGenerator to use the JDBC4 version of metadata queires as input

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Activity

            People

              dyret Dyre Tjeldvoll
              dyret Dyre Tjeldvoll
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: