16.13.2 Connection class

Table 16-22 lists limitations to the methods in the Connection class that are defined in the JDBC1.0 standard, while Table 16-23 lists limitations to the methods added in the JDBC2.0 basic standard.

Table 16-22 Limitations to the methods in the Connection class that are defined in the JDBC1.0 standard

Method defined in JDBC1.0 standardLimitation
setReadOnlyNot usable.
isReadOnlyUnconditionally returns false.
setCatalogNot usable.
getCatalogReturns null unconditionally.
setTransactionIsolationNot usable.
getTransactionIsolationReturns TRANSACTION_REPEATABLE_READ unconditionally.

Table 16-23 Limitations to the methods in the Connection class that are added in the JDBC2.0 basic standard

Method added in JDBC2.0 basic standardLimitation
createStatementA result set reflecting updating results is not usable. Therefore, if TYPE_SCROLL_SENSITIVE is specified for the result set type, the method changes it to TYPE_SCROLL_INSENSITIVE and sets an SQLWarning.
prepareStatement
prepareCall
getTypeMapUnconditionally throws SQLException because a user-defined type is not usable.
setTypeMap