Features of JDBC 3.0 API
- Reusabilty of prepared statements by
connection pools.
- 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:
Statement st=connection.createStatement();
int rowcount=st.executeUpdate("insert into employee values("tim"));
int rowcoutn=st.executeUpdate("insert into salary values(20000.0);
Savepoint sv=connection.setSavePoint("savepoint"); //create save point for inserts
int rowcount=st.executeUpdate("delete from employee");
connection.rollback(sv); //discard the delete statement but keeps the inserts
connection.commit(); //inserts are now permanent
- Retrieval of parameter metadata.
- It has added a means of retrieving values from
columns containing automatically generated 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 stored procedure parameters
to be called by name.