Features of JDBC API

Features of JDBC 1.0 API:

1). The JDBC 1.0 API was the first officially JDBC API launched consists of the following java classes and interfaces that you can open connections to particular databases.

2). This version includes a completely redesigned administration console with an enhanced graphical interface to manage and monitor distributed virtual databases.

 

-->

Features of JDBC 1.2 API:

1). New pass through schedulers for increased performance.

2). The DatabaseMetaData code has been refactored to provide more transparency with regard to the underlying database engine.

3). It supports Updatabale ResultSets.

Features of JDBC 2.0 API:

1). RowSet technology -- providing a convenient means of handling and passing data

2). Distributed transactions -- allowing a transaction to span diverse DBMS servers

3). The DataSource interface as a means of making a connection. The Java Naming and Directory InterfaceTM (JNDI) is used for registering a DataSource object with a naming service and also for retrieving it.

4). Pooled connections -- allowing connections to be used and reused

-->

Features of JDBC 2.1 API:

1). Miscellaneous features, including performance hints, the use of character streams, full precision for java.math.BigDecimal values, additional security, and support for time zones in date, time, and timestamp values.

2). Scrollable result sets--using new methods in the ResultSet interface that allow the cursor to be moved to a particular row or to a position relative to its current position

3). Custom mapping of user-defined types (UDTs)

4). Batch updates

5). New data types--interfaces mapping the SQL3 data types

6). Programmatic updates--using ResultSet updater methods

-->

Features of JDBC 3.0 API:

1). Addition of metadata for retrieving SQL type hierarchies

2). Pooled statements -- reuse of statements associated with a pooled connection

3). Addition of the java.sql.Types.DATALINK data type -- allows JDBC drivers access to objects stored outside a data source

4). Savepoints -- allow a transaction to be rolled back to a designated savepoint

5). Ability to programmatically update BLOB, CLOB, ARRAY, and REF values.

6). Properties defined for ConnectionPoolDataSource -- specify how connections are to be pooled

7). Ability to retrieve and update the SQL structured type instance that a Ref object references

8). Metadata for parameters of a PreparedStatement object

9). ResultSet holdability -- ability to specify whether cursors should be held open or closed at the end of a transaction

10). Ability to retrieve values from automatically generated columns

-->

Features of JDBC 4.0 API:

1). Connection management enhancements.

2). SQL XML support

3). SQL exception handling enhancements.

4). DataSet implementation of SQl using Annotations

5). Ability to programmatically update BLOB, CLOB, ARRAY, and REF values.

6). Properties defined for ConnectionPoolDataSource -- specify how connections are to be pooled