Monday, August 6, 2007

JDBC 3.0 Features

The Java Database Connectivity (JDBC) API key part of Java 2 Enterprise Edition (J2EE). It is the standards-based mechanism for the Java language to programmatically access relation databases.


New Features

CallableStatement interface has been updated so that you can now specify parameters by their names

Two new Datatypes have been added java.sql.Types.DATALINK and java.sql.Types.BOOLEAN

Auto-generated key or Auto Incremented key can be retrived by mentoioning optional flag value Statement.RETURN_GENERATED_KEYS in Statement.executeUpdate()

Statement interface to support multiple open ResultSets

jdbc3.0 allowed to define Transactional Savepoints during transaction and can roll back to any saved state.

Updating BLOB and CLOB Data Types