Features supported on all JDBC 4 releases

JDBC 4.0 added some functionality to the core API. This section documents the features supported by Derby.

All these JDBC 4.0 features are also supported by JDBC 4.1 and JDBC 4.2. See Features supported on JDBC 4.1 and above for information about features supported only by JDBC 4.1 and above. See JDBC 4.2-only features for information about features supported only by JDBC 4.2.

Note: These features are present only in a JDK 6 or higher environment.

These features are:

DataSources. The Derby implementations of javax.sql.DataSource support both JDBC 3 and JDBC 4.0 development. See javax.sql.DataSource interface: JDBC 3 and JDBC 4.0 features.
Autoloading of JDBC drivers. In earlier versions of JDBC, applications had to manually register drivers before requesting Connections. With JDBC 4.0 and above, applications no longer need to issue a Class.forName() on the driver name; instead, the DriverManager will find an appropriate JDBC driver when the application requests a Connection.
SQLExceptions. JDBC 4.0 introduced refined subclasses of SQLException. See Refined subclasses of SQLException.
Wrappers. JDBC 4.0 introduced the concept of wrapped JDBC objects. This is a formal mechanism by which application servers can look for vendor-specific extensions inside standard JDBC objects like Connections, Statements, and ResultSets. For Derby, this is a vacuous exercise because Derby does not expose any of these extensions.
Statement events. With JDBC 4.0 and above, connection pools can listen for Statement closing and Statement error events. New methods were added to javax.sql.PooledConnection: addStatementEventListener and removeStatementEventListener.
Streaming APIs. JDBC 4.0 added new overloads of the streaming methods in CallableStatement, PreparedStatement, and ResultSet. These are the setXXX and updateXXX methods which take java.io.InputStream and java.io.Reader arguments. The new overloads allow you to omit the length arguments or to specify long lengths. If you omit the length argument when the stream object is a LOB greater than a single page in size, performance will be impaired if you later retrieve the length of the LOB. However, if you are simply inserting or reading data, performance is unaffected.
New methods. New methods were added to the following interfaces: javax.sql.Connection, javax.sql.DatabaseMetaData, and javax.sql.Statement. See java.sql.Connection interface: JDBC 4.0 features, java.sql.DatabaseMetaData interface: JDBC 4.0 features, java.sql.Statement interface: JDBC 4.0 features.