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

DatabaseMetadata.getColumns() orders rows differently from ODBC SQLColumns()

XMLWordPrintable

    • Icon: Enhancement Enhancement
    • Resolution: Fixed
    • Icon: P4 P4
    • 6
    • 5.0
    • core-libs
    • b91
    • x86
    • windows_xp
    • Not verified

      A DESCRIPTION OF THE PROBLEM :
      The J2SE 5 API says that DatabaseMetadata.getColumns() should order by "TABLE_SCHEM, TABLE_NAME, and ORDINAL_POSITION." This conflicts with the equivalent ODBC function, SQLColumns, which orders by "TABLE_CAT, TABLE_SCHEM, TABLE_NAME, and ORDINAL_POSITION." The ODBC ordering makes more sense in terms of the hierarchy of database objects.


      URL OF FAULTY DOCUMENTATION :
      http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getColumns(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String)

            lancea Lance Andersen
            rmandalasunw Ranjith Mandala (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved:
              Imported:
              Indexed: