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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.