blogger templates blogger widgets
This is part of a list of blog posts.
To browse the contents go to

Introduction and History - JDBC

Starting with JDBC

Installing oracle 11g.

There are 2 ways one could make JDBC connection.
1. Class managed
2. Container managed

And also from connections perspective there are
1. singular connections and
2. pooled connections

We will see combinations of all 4 types.

But before all that we need a DBMS software, a database created using it, few tables to operate on and finally the JDBC driver that helps our java programs to connect with the DBMS software. There is one more thing that is inclusive and it's the JDBC API that comes along with the JDK installation.

History of JDBC API

Do not worry if you don't understand anything in this section it's as it is from oracle docs.

JDBC (Java DataBase Connectivity) provides standard library for accessing relational databases.

The first version of JDBC was released as part of JDK 1.1 on Feb, 1997.

Then came JDBC 2.0.

JDBC 2.0 represented the partitioning of the JDBC API into core package and standard extension.
With the core JDBC package fulfilling functionality present in JDBC 1.2 guaranteeing backward compatibility and the standard extension package containing new functionality distributed separately of the JDK.

The new functionality of the standard extension package was placed under Java's javax.sql package and it included features like: JNDI support for JDBC Data Sources, connection pooling, rowsets and distributed transactions.

Then came JDBC 3.0

JDBC 3.0 represented the inclusion of the standard extension package (i.e. javax.sql) into the JDK itself (i.e. java.sql), as well as additional enhancements to the API's overall functionality.

Among the enhancements present in JDBC 3.0 over JDBC 2.0 are:
    Better connection pooling, increased support for SQL99 features (SQL99 is database industry standard for SQL language), updated metadata APIs, named parameters in Callable statements in order to support parameter names in stored procedures, as well as new and updated data types.

New features of the JDBC 3.0 include:
    Retrieving auto-generated keys, integration support for the Java Connector Architecture(JCA), ResultSet hold-ability, PreparedStatement pooling, as well as savepoints for transactions.

Now we have JDBC 4.0

JDBC 4.0 represents the latest version of the JDBC API and forms part of the JDK 6.0 (i.e. Java SE 6).

Among the enhancements present in JDBC 4.0 over JDBC 3.0 are:
    Enhanced driver and connection management, increased support for SQL2003 (successor to SQL99), better exception handling, as well as new and updated dat a types.

New features of the JDBC 4.0 include:
    SQLXML and XML support, as well as support for national character set conversion -- supported through SQL2003.

Continue reading: JDBC API - Getting Started

No comments:

Post a Comment