Adopted SQL2004 features
Ability to have multiple open ResultSet objects
Adopted SQL92 features
Support for CLOB and BLOB objects
It is possible to code stored procedures in Java
In the call to a stored procedure with the CallableStatement, it is possible to specify parameters by names
Automatic object-relational mapping
Adopted ANSI SQL 2006 Specification
Creating a pool of database connections
Connection pool configuration
The new "commit" and "rollback" methods of the Connection interface allows developers to set transactions
Added the data type java.sql.Types.BOOLEAN. BOOLEAN is logically equivalent to BIT.
It is possible to call stored procedures
|