Version of JDBC
The various Versions of JDBC are given below:
- The JDBC 1.0 API
- The JDBC 1.2 API
- The JDBC 2.0 Optional Package API
- The JDBC 2.1 core API
- The JDBC 3.0 API
- The JDBC 4.0 API
Feature of JDBC 1.0 API
- It consists to all class and interface of java by which we can open connection of
a particular database.
- It includes a redesigned administration console and graphical interface which manage and
monitor to the distributed virtual databases.
Feature of JDBC 1.2 API
- It is provide more transparency to the underlying database engine.
- It is support to Update ResultSets.
- For increasing the performance allow new pass through scheduler.
Feature of JDBC 2.0 Optional Package API
- For making a connection with database uses the DataSource interface.
- It is allow the Pooling connection, which is help to reuse the connections.
- Distributed transactions are possible.
- It is allowed to handling and passing the data using Rowset technology.
Feature of the JDBC 2.1 core API
- It provides the facility to move to a specific row.
- It provides the method in java for making update in a database tables.
- It is allowed to multiple SQL statements in a database batch.
- It is Supports for time zones in Date, Time, and Timestamp values.
Feature of JDBC 3.0 API
- It allows the reusability of prepared statements by connection pooling technique.
- Added a new data type java.sql.BOOLEAN
- Retrieving of parameterized metadata.
- Added a new feature which is retrieving values from columns containing automatically
- New concept of savepoint.
- The data of the Blob and Clob can be altered.
Feature of JDBC 4.0
- Auto-loading of JDBC driver class.
- Connection management enhancements.
- Support for RowId SAL type.
- SQL exception handling enhancements.
- DataSet implementation of SQL using Annotations.
- SQL XML support.