Features of JDBC 3.0 API Posted on: April 13, 2007 at 12:00 AM
Reusabilty of prepared statements by connection pools.
In this version there is number of properties defined for the ConnectionPoolDataSource.
Features of JDBC 3.0 API
Reusabilty of prepared statements by
In this version there is number of properties
defined for the ConnectionPoolDataSource. These properties can be
used to describe how the PooledConnection objects created by DataSource
objects should be pooled.
A new concept has been added to this API is of savepoints:
One of the useful new features is transactional savepoints. With JDBC 3.0,
the transactional model is now more flexible. Now you can start a
transaction , insert several rows in it and then create a savepoint. This
savepoint serves as a bookmark. The application can rollback to the
savepoint and then commit the group of inserts as if the updates have never
been attempted. For eg:
int rowcount=st.executeUpdate("insert into employee
pdate("insert into salary values(20000.0);
point for inserts
int rowcount=st.executeUpdate("delete from employee");
//discard the delete statement but keeps the
//inserts are now permanent
Retrieval of parameter metadata.
It has added a means of retrieving values from
columns containing automaticallygenerated values.
Added a new data type i.e. java.sql.BOOLEAN.
Passing parameters to CallableStatement.
The data in the Blob and Clob can be
altered: JDBC 3.0 introduces a standard mechanism for updating BLOB
and CLOB data.
DatabaseMetaData API has been added.
It allows storedprocedure parameters
to be called by name.