java.sql.DatabaseMetaData interface

This section discusses java.sql.DatabaseMetaData functionality in Derby.

For methods that take a catalog parameter, always specify null for this parameter, since Derby does not support catalogs. Similarly, methods that return a catalog in the ResultSet will always return null in that column.

The Derby implementation of the getColumns method returns an empty ResultSet if the table specified in the third argument is a SYNONYM.

The Derby implementation of the getResultSetHoldability method returns ResultSet.HOLD_CURSORS_OVER_COMMIT.