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 Video Tutorial: Create, Read, Update and Delete (CRUD) Operation examples JDBC Video tutorial - How to read Data from MySQL Database? JDBC Video tutorial - How to delete Data in a MySQL Database? Solving java.lang.ClassNotFoundException: com.mysql.jdbc.Driver exception JDBC Video tutorial - How to update Data in a MySQL Database? JDBC Video Tutorial- How to insert data into MySQL database table? JDBC Video Tutorial: How to download JDBC Driver for MySQL? JDBC Tutorial - Writing first JDBC example and running in Eclipse Java Cross Join MySQL Database Connectivity Example In Java Change Column Name in MySQL Java Mysql Connection Example JDBC ODBC Connection In Java ResultSet In Java Prepared Statement Example JdbcRowSet interface Java JdbcRowSet Example First Step towards JDBC! JDBC Training, Learn JDBC yourself Jdbc Get Column Names JDBC Example with MySQL JDBC Prepared Statement Update JDBC Prepared Statement Insert JDBC Prepared Statement Example JDBC Prepared statement Close JDBC Prepared Statement Addbatch JDBC Nested Resultset JDBC-Odbc Connection JDBC-Odbc Connectivity JDBC Insert Preparedstatement JDBC Insert Null JDBC Get Metadata JDBC Insert Record Jdbc Insert Statement JDBC Meta Data Get tables Jdbc Mysql Connection String Jdbc Mysql Connection Url JDBC Next Jdbc Get Connection JDBC Get Int JDBC Exception JDBC Get Row Count JDBC Functions JDBC Fetch JDBC Execute Update Example JDBC Execute Statement JDBC Execute Query JDBC Drive For Mysql JDBC Connectivity Code In Java JDBC connection timeout

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