JDBC Versions

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.

JDBC Versions


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.

Features of JDBC 1.0 API

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.

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). It supports Updatabale ResultSets.

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

3) New pass through schedulers for increased performance.

Features of The JDBC 2.0 Optional Pacakage 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 connections.

4). In this version the distrbuted transactions is possible.

5). It provides a way of handling and passing data using Rowset technology.

Features of the JDBC 2.1 core API.

1). Scroll forward and backward in a result set 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 a database as a unit, or batch.

4). It uses the SQL3 datatypes as column values. SQL3 types are Blob, Clob, Array, Structured type, Ref.

5). Increased support for storing persistent objects in the java programming language.

6). Supports for time zones in Date, Time, and Timestamp values.

7). Full precision for java.math.BigDecimal values.

Features of JDBC 3.0 API

1). Reusabilty of prepared statements by connection pools.

2). In this version there is 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 a means of retrieving values from columns containing automatically generated values.

6). Added a new data type i.e. java.sql.BOOLEAN.

7). Passing parameters to CallableStatement.

8). The data in the Blob and Clob can be altered.

9). DatabaseMetaData API has been added.

Features of JDBC 4.0 :

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

Share on Google+Share on Google+

JDBC Versions

Posted on: April 13, 2007 If you enjoyed this post then why not add us on Google+? Add us to your Circles



Discuss: JDBC Versions   View All Comments

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
amrita singh
April 22, 2011

Khan Tauseef Ahmed
July 3, 2011
Comple Advance java

JDBC explanation is Best.
November 14, 2011
about the script

Its very informative for beginners...
patel vishal
February 2, 2012
database driver

Why i am not created access and SQL database driver in java? Any software required?
Adeel Ahmed
May 21, 2012
JDBC driver not working for Eclipse 4.2 IDE

Hi! I have installed Apacha Tomcat 7 ,mysql 5.5 and eclipse 4.2.I copied mysql-connector-java-5.1.20-bin.jar to Apache/lib folder.When I make wizard based connection.The connection establishes successfully.But when I use programming package DataAccessWithJava; import java.sql.*; import java.lang.*; public class MysqlConnect{ public static void main(String[] args) { System.out.println("MySQL Connect Example."); Connection conn = null; String url = "jdbc:mysql://localhost:3306/test"; String dbName = "test"; String driver = "com.mysql.jdbc.Driver"; String userName = "root"; String password = "root"; try { Class.forName(driver).newInstance(); conn = DriverManager.getConnection(url+dbName,userName,password); System.out.println("Connected to the database"); conn.close(); System.out.println("Disconnected from database"); } catch (Exception e) { e.printStackTrace(); } } } java.lang.ClassNotFoundException: com.mysql.jdbc.Driver this error occurs and no help is available