PURE Java™ 2

JDBC 2.0 Techniques

This section gives a brief overview of the most important JDBC 2.0 enhancements to the JDBC core APIs. Although they are very interesting, the standard extensions, such as support for reading rows of any tabular data source (such as a spreadsheet) and allowing an Enterprise JavaBean to work with connection pools, are not covered. Here are the main new features of the JDBC 2.0 core APIs:

• Scrollable ResultSets—You can move both forward and backward in a ResultSet.

• Programmatic updates to a ResultSet—You can modify the contents of a ResultSet using Java method calls. This automatically updates the underlying relational table.

• Batch updates—You can submit multiple DML statements, like insert or update, at once.

• User-defined data ...