DatabaseMetaData functionality not supported

In the current release, Derby does not provide all of the DatabaseMetaData functionality. The following JDBC requests result in empty result sets, in the format required by the JDBC API:
  • getColumnPrivileges
  • getTablePrivileges

Derby does not implement privileges, and thus has no information to provide for these calls.

getBestRowIdentifier looks for identifiers in this order:
  • a primary key on the table
  • a unique constraint or unique index on the table
  • all the columns in the table

Because of this last choice, it will always find a set of columns that identify a row. However, if there are duplicate rows in the table, use of all columns might not necessarily identify a unique row in the table.

Related reference
DatabaseMetaData result sets
Parameters to getProcedureColumns
Columns in the ResultSet returned by getProcedureColumns