New Features of java.sql & javax.sql packages

[Ko Ko Naing]

java.sql and javax.sql Features Introduced in the JDBC 3.0 API
Pooled statements -- reuse of statements associated with a pooled connection
Savepoints -- allow a transaction to be rolled back to a designated savepoint
Properties defined for ConnectionPoolDataSource -- specify how connections are to be pooled
Metadata for parameters of a PreparedStatement object
Ability to retrieve values from automatically generated columns
Ability to have multiple ResultSet objects returned from CallableStatement objects open at the same time
Ability to identify parameters to CallableStatement objects by name as well as by index
ResultSet holdability -- ability to specify whether cursors should be held open or closed at the end of a transaction
Ability to retrieve and update the SQL structured type instance that a Ref object references
Ability to programmatically update BLOB, CLOB, ARRAY, and REF values.
Addition of the java.sql.Types.DATALINK data type -- allows JDBC drivers access to objects stored outside a data source
Addition of metadata for retrieving SQL type hierarchies

[Pradeep bhatt]

http://www-106.ibm.com/developerworks/java/library/j-jdbcnew/

[Ko Ko Naing]

Urs are also cool, man... From IBM site... Hope people got knowledge from it too...