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) |
Print-friendly Version
