80 Advanced Java Tutorial | JDBC | Various Versions of JDBC & its features | adv java
Advanced Java JDBC Tutorial :adv java : java Database Connectivity| Various Versions of JDBC & its features:
1. JDBC 1.0 API
2. JDBC 1.2 API
3. JDBC 2.0 API (optional package API)
4. JDBC 2.1 API core API
5. JDBC 3.0 API
6. JDBC 4.0 API
Features:
A) The JDBC 1.0 API was the first officially JDBC API launched consists of the following java classes and interfaces that you can open connecitons to particular databases.
This version includes a comletely redesigned administration console with an enhanced graphical interface to manage and monitor distributed virtual databases.
B)Features of JDBC 1.2 API:
---------------------------
1) It supports Updatabale ResultSets.
2) The DatabaseMetaData code has been refactored to provide more transperency with regard to the underlying database engine.
3) New pass through schedulers for increased performance.
C). Features of JDBC 2.0 API (optional package API):
-----------------------------------------------------
1) The use of DataSource interface for making a connection.
2) Use of JNDI to specify and obtain database connections.
3) It allows us to use Pooled Connections, that is we can reuse the conncetions.
4) In this version the distributed transactions is possible.
5) It provides a way of handling and passing data using Rowset technology.
D). Features of JDBC 2.1 API core API:
-------------------------------------
1) Scroll forward and backward in a ResultSet or has the ability to move to a specific row.
2) Instead of using SQL commands, we can make updates to a database tables using methods in the java programming language.
3) We can use multiple SQL statements in a database as a unit or batch.
4) It uses the SQL3 datatypes as column values. SQL3 types are blob, clob, array, structured type, etc.
5) Increased support for storing persistent objects in the java.
6) Supports for time zone in Date, Time and Timestamp values.
7) Full precision for java.math.BigDecimal values.
E). Features of JDBC 3.0 API:
----------------------------
1) Reusabilithy of PreparedStatement by connection pools.
2) The number of properties defined for the ConnectionPoolDataSource. These properties can be used to describe how the PooledConnection objects created by DataSource objects should be pooled.
3) A new concept has been added to this API is of savepoints.
4) Retrieval of parameter metadata.
5) It has added, retrieving values from columns conataining automatically generated values.
6) Added a new data type i.e. java.sql.BOOLEAN
7) The data in the Blob & clob can be altered.
8) Passing Paramenters to the CallableStatement.
9) DatabaseMetaData API has been added.
F). Features of JDBC 4.0 API
----------------------------
1) Auto leading 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.