Features

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)