JDBC

The various Versions of JDBC are given below:

1. The JDBC 1.0 API
2. The JDBC 1.2 API
3. The JDBC 2.0 Optional Package API
4. The JDBC 2.1 core API
5. The JDBC 3.0 API
6. The JDBC 4.0 API

1. It consists to all class and interface of java by which we can open connection of a particular database.
2. It includes a redesigned administration console and graphical interface which manage and monitor to the distributed virtual databases.

1. It is provide more transparency to the underlying database engine.
2. It is support to Update ResultSets.
3. For increasing the performance allow new pass through scheduler.

1. For making a connection with database uses the DataSource interface.
2. It is allow the Pooling connection, which is help to reuse the connections.
3. Distributed transactions are possible.
4. It is allowed to handling and passing the data using Rowset technology.

1. It provides the facility to move to a specific row.
2. It provides the method in java for making update in a database tables.
3. It is allowed to multiple SQL statements in a database batch.
4. It is Supports for time zones in Date, Time, and Timestamp values.

1. It allows the reusability of prepared statements by connection pooling technique.
2. Added a new data type java.sql.BOOLEAN
3. Retrieving of parameterized metadata.
4. Added a new feature which is retrieving values from columns containing automatically generated values.
5. New concept of savepoint.
6. The data of the Blob and Clob can be altered.

1. Auto-loading of JDBC driver class.
2. Connection management enhancements.
3. Support for RowId SAL type.
4. SQL exception handling enhancements.
5. DataSet implementation of SQL using Annotations.
6. SQL XML support.