There are some definite improvements with the JDBC 2.0 API. Some
of those are summarized in the following list.
- Batch fetch: JDBC 2.0 allows retrieving a batch of records from
the Database.
- Scrollable Resultset: One can go back and forth in the resultset.
- Easy update Methods like updateRow() make updating the current
row easy w/o writing a SQL update statement.
- 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.
New on the Java Boutique:
New Review:
Time Management Made Easy with the Quartz Enterprise Job Scheduler
Why not just use the Java timer API? This open source scheduling
API boasts simplicity, ease-of-integration, a well-rounded feature
set, and it's free!
New Applet:
Reverse Complement
Reverse Complement is a simple applet that converts DNA or RNA
sequences into three useful formats.
Elsewhere on internet.com:
WebDeveloper Java
Lots of Java information on webdeveloper.com
WDVL Java
Thorough Java resource at the Web Developer's Virtual Library.
ScriptSearch Java
Hundreds of free Java code files to download.
jGuru: Your View of the Java Universe
Customizable portal with online training, FAQs, regular news updates, and tutorials.