java.sql.Connection interface: supported JDBC 2.0 methods

Table 1. JDBC 2.0 Connection Methods Supported
Returns	Signature
Statement	createStatement( int resultSetType, int resultSetConcurrency)
PreparedStatement	prepareStatement(String sql, int resultSetType, int resultSetConcurrency)
CallableStatement	prepareCall(String sql, int resultSetType, int resultSetConcurrency

Implementation notes

ResultSet.TYPE_FORWARD_ONLY and ResultSet.TYPE_SCROLL_INSENSITIVE are the only result set types supported. If you request TYPE_SCROLL_SENSITIVE, Derby issues an SQLWarning and returns a TYPE_SCROLL_INSENSITIVE ResultSet.

These methods support both ResultSet.CONCUR_READ_ONLY and ResultSet.CONCUR_UPDATABLE concurrencies.