Uploaded image for project: 'JDK'
  1. JDK
  2. JDK-6439784

Ordering for columns returned via getProcedureColumns needs to match ODBC

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: P3 P3
    • 6
    • 1.4.1
    • core-libs
    • None
    • b91
    • generic
    • generic
    • Not verified

      The ordering of columns returned by getProcedureColumns should match ODBC which is defined as
      SQLProcedureColumns returns the results as a standard result set, ordered by PROCEDURE_CAT, PROCEDURE_SCHEM, PROCEDURE_NAME, and COLUMN_TYPE. Column names are returned for each procedure in the following order: the name of the return value, the names of each parameter in the procedure invocation (in call order), and then the names of each column in the result set returned by the procedure (in column order).

      Need to add see PROCEDURE_CAT as the first column in the order by clause
      javadoc for getColumnPrivileges() and getTablePrivileges() GRANTOR column is missing the definition of its data type returned which is a String

            lancea Lance Andersen
            lancea Lance Andersen
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:
              Imported:
              Indexed: