JDBC: History and Features Evaluations

JDBC History

Sun Microsystems released JDBC on February 19, 1997 as part of Java Development Kit (JDK) 1.1 .Since then it has been part of the Java Platform, Standard Edition (Java SE).

The JDBC classes are divided in two packages:

  • java.sql
  • javax.sql.

JDBC version by Release

J2SE 1.4 : JDBC version 3.1 developed by the JAVA community process with JSR 54 specification.

J2SE 1.6 : JDBC version 4.0 developed with concept of Rowset and JSR 221 specification.

J2SE     7: JDBC version 4.1 specified by a maintenance release 1 of JSR 221 specification.

J2SE    8: JDBC version 4.1 specified by a maintenance release 2 of JSR 221 specification.

J2SE    9: JDBC version 4.1 specified by a maintenance release 3 of JSR 221 specification.
The latest version of JDBC is 4.1 currently. Java used primary package java.sql and javax.sql  jdbc api to ease and simplify the coding to database interactivity.

JDBC 3 Features

Below are new features in these packages include changes in the following areas:

  • Jdbc RowSet
  • Savepoint in transaction management to rollback and release the savepoint by              Connection.setSavepoint()

Connection.rollback(Savepoint svpt)

Connection.releaseSavepoint(Savepoint svpt) methods.

  • ResultSet and Statement Caching  for Connection Pooling.
  • Switching between Local and Global Transactions .
  • Retrieval of auto generated keys by the method getGeneratedKeys().

JDBC 4 Features

Below are new features in these packages include changes in the following areas:

  • Automatic database driver loading don’t need to write Class.forName().
  • Connection and statement interface enhancements. Some new methods added for PreparedStatement, CallableStatement, ResultSet etc.
  • DataSource improvements.
  • Event Handling support in Statement for Connection Pooling to listen statement error and statement closing events.
  • Exception handling improvements.
  • Enhanced BLOB/CLOB functionality.
  • National character set support.
  • SQL ROWID access.
  • SQL 2003 XML data type support.
  • Annotations.

More on JDBC

Follow below links to know more on JDBC and solving JDBC issues :

JDBC Tutorial

JDBC Sample Code

JDBC Issues and Solutions

JDBC Interview Questions And Answers

Advertisements

This site uses Akismet to reduce spam. Learn how your comment data is processed.