java.sql.Connection

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 scrolling 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. However, you can only request an updatable ResultSet that has a TYPE_FORWARD_ONLY scrolling type. If you request an updatable ResultSet with SCROLL_SENSITIVE or SCROLL_INSENSITIVE types, Derby issues an SQLWarning and returns TYPE_SCROLL_INSENSITIVE READ_ONLY ResultSet.

(Use Connection.getWarnings to see warnings.)