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.

Related reference
java.sql.Driver interface
java.sql.DriverManager.getConnection method
java.sql.Connection interface
java.sql.Statement interface
java.sql.CallableStatement interface
java.sql.PreparedStatement interface
java.sql.ResultSet interface
java.sql.ResultSetMetaData interface
java.sql.SQLException class
java.sql.SQLWarning class
java.sql.Savepoint interface
Mapping of java.sql.Types to SQL types
JDBC Package for Connected Device Configuration/Foundation Profile (JSR 169)
Features supported on all JDBC 4 releases
Features supported on JDBC 4.1 and above
JDBC 4.2-only features
JDBC escape syntax