| Lesson 2 | JDBC versions |
| Objective | Describe the different pieces of the JDBC Specification. |
JDBC Versions
The JDBC specification is now at release 4.1. This specification separates JBDC features into two collections of services: the core sets and the advanced sets.
The table below gives a description of these two pieces of the JDBC specification.
| JDBC version |
Description |
| JDBC 2.1 Core API |
JDBC 2.1 Core API is part of the J2EE. Like previous versions, JDBC 2.1 Core API is used for essential
database tasks (e.g., to create connections, execute statements and prepared statements, or run batch queries) and supports the SQL:1999data types (i.e., BLOB and CLOB, discussed later), SQL 2 types, batch updates, scrollable result sets, and transaction isolation.
|
| JDBC Optional Package API |
JDBC Optional Package API, also called JDBC 2.0 Extension, improves the standard JDBC 2.0 API. For example, it adds improved connectivity, connection pooling, and distributed transactions. |
Different JDBC packages
There are two different packages that correspond to the different pieces. The classes for the core set are in the java.sql package, while the javax.sql package contains the optional classes. There are different sources for the different packages, as well. The core set is included with the Standard Edition of the JDK, and the optional set comes with the Enterprise Edition of the JDK (also known as the J2EE edition).
In the first part of this course, we will focus our work on the services provided by the core package.
In the next lesson, you will learn more about the process of involving JDBC in a database connection.
JDBC Version - Quiz