JDBC Driver for SQL/MP 3.0

The JDBC specification identifies several areas that are optional and need not be supported if the database
management system does not provide support. The JDBC Driver for SQL/MP does not support these optional
interfaces:
SQL3 data types, which include Array, Ref, and Struct. SQL/MP does not support those data types.
Custom type-maps used to map between SQL user-defined data types and Java classes. These type-maps include
SQLData, SQLInput, and SQLOutput, which are used in conjunction with custom type-maps. SQL/MP does not
support user-defined data types.
Any methods that use java.util.Map, such as Connection.setTypeMap(). These methods are not supported
because their only function is to provide custom type-maps, which are not supported.
XAConnection and SADataSource classes, which are used to support distributed transactions. None of the classes
or interfaces in javax.transaction.xa are supported.
All other areas of the JDBC Driver for SQL/MP are compliant with the JDBC specifications, including such optional
features as BLOBs, CLOBs, and DataSource support.
JDBC Driver for SQL/MP Support for JDBC 3.0
This subsection provides specific information about how the JDBC Driver for SQL/MP supports the JDBC 3.0 API in
the areas of:
Result Sets
Metadata Support
Batch Updates
BLOBs and CLOBs
JDBC 2.0 Standard Extensions
Result Set Support
These paragraphs describe JDBC/MP's Result Set support for the areas of scrolling and concurrency:
Scrolling
JDBC identifies three types of result sets: forward-only, scroll-insensitive, and scroll-sensitive. Both scroll-related
result set types support scrolling, but they differ in their ability to make changes in the database visible when the result
set is open. A scroll-insensitive result set provides a static view of the underlying data it contains (the data is fixed
when the result set is created). A scroll-sensitive result set is sensitive to underlying changes that are made in the data
when the result set is open.
The JDBC Driver for SQL/MP supports scroll-insensitive result sets. JDBC/MP supports scroll-insensitive result sets
by storing the entire result set in memory. For this reason, if you select a large scroll-insensitive result set, performance
can be affected. In some instances, the JDBC Driver for SQL/MP might choose an alternative result set type when the
result set is created.
Concurrency
An application can choose from two different concurrency types for a result set: read-only and updatable. A read-only
result set does not allow updates of its contents. An updatable result set allows rows to be updated, deleted, and
inserted.