JDBC Technology Core features (the java.sql package)

Feature Benefit
Result set enhancements Ease of programming
 - Scrollable result set Ability to move a result set's cursor to a specific row. This feature is used by GUI tools and for programmatic updating
 - Updatable result set Ability to use Java programming language commands rather than SQL
New data types support Performance improvement (ability to manipulate large objects such as BLOB and CLOB without bringing them to the client from the DB server)
Batch updates Performance improvement (sending multiple updates to the DB for processing as a batch can be much more efficient than sending update statements separately)
Savepoints Ability to roll transactions back to where a savepoint is set

JDBC Optional Package features (the javax.sql package)

The features in the javax.sql package make the JDBC API a server-side technology as well as a client API.

Feature Benefit
JNDI support Ease of deployment (gives JDBC driver independence, makes JDBC applications easier to manage)
Connection pooling Performance improvement (a connection pool is a cache of database connections that is maintained in memory, so that the connections may be reused)
Distributed transactions Important for implementing a distributed transaction processing system
JavaBeans ( RowSet objects)

Send data across a network to thin clients, such as web browsers, laptops, PDAs, and so on

Access any tabular data source, even spreadsheets or flat files

Make results sets scrollable or updatable when the JDBC driver does not support scrollability and updatability

Reference to JDBC Rowset Encapsulate a driver as a JavaBeans component for use in a GUI
Statement pooling Performance improvement (by pooling statements as well as pooling connections)
Left Curve
Java SDKs and Tools
Right Curve
Left Curve
Java Resources
Right Curve