# JDBC 4.2-only features

JDBC 4.2 adds some functionality to the core API. This section documents the JDBC 4.2 features supported by Derby.

For information on features supported by all versions of JDBC 4, see JDBC reference. For information on features supported by both JDBC 4.1 and JDBC 4.2, see Features supported on JDBC 4.1 and above.

Note: JDBC 4.2 features are present only in a JDK 8 or higher environment.

- JDBC support for Java SE 8 Compact Profiles
  Derby provides support for Compact Profiles on the Java SE 8 platform by means of a group of JDBC DataSource classes.
- java.sql.DatabaseMetaData interface: JDBC 4.2 features
  Derby implements all of the new metadata methods added by JDBC 4.2.
- java.sql.SQLType interface
  JDBC 4.2 introduces a new data type identifier, java.sql.SQLType, to help databases describe data types which do not appear in the ANSI/ISO SQL Standard. Databases which provide non-standard types can provide their own implementations of SQLType.

Parent topic: JDBC reference
Related reference
java.sql.Driver interface
java.sql.DriverManager.getConnection method
java.sql.Connection interface
java.sql.DatabaseMetaData 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.SQLXML interface
java.sql.Savepoint interface
Mapping of java.sql.Types to SQL types
Features supported on JDBC 4.1 and above
JDBC escape syntax