What is new in JDBC 2.0 ?

Scrollable result sets

Scroll forward and backward in a result set or move to a specific row

[ TYPE_SCROLL_SENSITIVE, previous(), last(), absolute(), relative(), etc.]

Batch Updates functionality

Send multiple SQL statements to the database as a unit, or batch 

[addBatch(), executeBatch()]

New data types

Use the new SQL3 datatypes as column values like Blob, Clob, Array, Struct, Ref. 

Custom  mapping of user-defined types (UTDs)

New data manipulation methods

Make updates to database tables using methods in the Java programming language instead of using SQL commands.

(updateRow(), insertRow(), deleteRow(), etc.)

Java applications can now use the ResultSet.updateXXX methods.

Miscellaneous features

• Performance hints
• Use of character streams
• Full precision for java.math.BigDecimal values
• Additional security
• Support for time zones in date, time, and timestamp values.