JDBC 2.0 Enhancements

There are several enhancements to JDBC in Java 2, including the new JDBC version number 2.0. Perhaps the two most significant enhancements are scrollable cursors and updateable result sets. Before discussing them, let's briefly review JDBC. JDBC provides a database-neutral way to send requests to a database management system (DBMS). Usually, this is done with SQL, Structured Query Language, although other options such as OQL, Object Query Language, are technically possible. In order to provide for this flexibility, JDBC depends upon third parties to provide JDBC drivers. A driver implements the interfaces in the java.sql package, such as Statement and Connection. Java does not check the SQL statements you code for validity. ...

Get PURE Java™ 2 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.