JDBC 2.0

There are some definite improvements with the JDBC 2.0 API. Some of those are summarized in the following list.

1. Batch fetch: JDBC 2.0 allows retrieving a batch of records from the Database.
2. Scrollable Resultset: One can go back and forth in the resultset.
3. Easy update Methods like updateRow() make updating the current row easy w/o writing a SQL update statement.
4. Batch updates: Updates and inserts can be sent to the underlying RDBMS in Batches.

To learn more about how to use these features check out the JDBC 2.0 tutorial.

NOTE: Which of these features are supported and to what level is also dependent on your JDBC driver.

Finally the latest development on making database access (from a java application such as JSP) simpler is JDO. Check out this FAQ for more details.

Now let's move on to our next topic, Connection Pooling, which is more relevant with our primary goal: building web applications with Servlets and JSP.

The Complete ValidateUser Method
Building Web Applications Using Servlets and JSP Part II
Connection Pooling and Introduction to Application Servers