JDBC for SQL Server - Herong's Tutorial Examples - v3.13, by Herong Yang
JDBC Version and History
This section provides some quick information about JDBC versions and history.
The following table lists JDBC past versions and implementations:
Year JDBC Version JSR Specification JDK Implementation ---- ------------ ----------------- ------------------ 2017 JDBC 4.3 JSR 221 Java SE 9 2014 JDBC 4.2 JSR 221 Java SE 8 2011 JDBC 4.1 JSR 221 Java SE 7 2006 JDBC 4.0 JSR 221 Java SE 6 2001 JDBC 3.0 JSR 54 JDK 1.4 1999 JDBC 2.1 JDK 1.2? 1997 JDBC 1.2 JDK 1.1?
Main new features introduced in JDBC 4.3 are:
Main new features introduced in JDBC 4.2 are:
Main new features introduced in JDBC 4.1 are:
Main new features introduced in JDBC 4.0 are:
Note that JDBC 4.3 API has been implemented in Java SE 9. But JDBC drivers of specific database servers for JDBC 4.3 API may still not available. Since JDBC 4.3 API is backward compatible, there is no problem with using Java SE 9 or higher with JDBC 4.2, 4.1, 4.0 or 3.0 drivers, as long as you do not use the new methods or classes there were introduced in JDBC 4.3 API.
Table of Contents
►JDBC (Java Database Connectivity) Introduction
Establishing Connections from JDBC to Databases
DriverManager - Loading JDBC Driver
DriverManager - Connection URL
Microsoft SQL Server Express Edition
Microsoft JDBC Driver for SQL Server
Microsoft JDBC Driver - Query Statements and Result Sets
Microsoft JDBC Driver - DatabaseMetaData Object
Microsoft JDBC Driver - DDL Statements
Microsoft JDBC Driver - DML Statements
SQL Server - PreparedStatement
SQL Server CLOB (Character Large Object) - TEXT
SQL Server BLOB (Binary Large Object) - BLOB
JDBC-ODBC Bridge Driver - sun.jdbc.odbc.JdbcOdbcDriver
JDBC-ODBC Bridge Driver - Flat Text Files
JDBC-ODBC Bridge Driver - MS Access