List of Tested JDBC Drivers

This section provides a list of JDBC drivers tested with different versions of Java and database servers: Derby, MS Access, MySQL, Oracle and SQL Server.

Several JDBC drivers were tested in this book with different Java versions for different database servers (Derby, MS Access, MySQL, Oracle, SQL Server) and versions.

A quick summary of their main attributes is provided here as a comparison and a reference:

Driver Name: Apache Derby Network Client JDBC Driver
------------

Driver JAR File: derbyclient.jar
Vendor: Apache
JDBC Type: Type 4
JDK Tested: 13
Server name: Apache Derby
Server version: 10.15.1.3 - (1853019)
Driver name: Apache Derby Network Client JDBC Driver
Driver version: 10.15.1.3 - (1853019)
JDBC major version: 4
JDBC minor version: 2

Driver Name: JDBC-ODBC Bridge
------------
Driver JAR File: None (included in Java SE 1.6)
Vendor: Sun
JDBC Type: Type 1
JDK Tested: 1.6
Driver Version:  2.0001
JDBC Version: 4.0
Database Name: Any database with an ODBC driver
Database Version: N/A


Driver Name: MySQL Connector/J
------------
Driver JAR File: mysql-connector-java-8.0.27.jar
Vendor: MySQL AB
JDBC Type: Type 4
JDK Tested: 13
Server name: MySQL
Server version: 8.0.17
Driver name: MySQL Connector/J
Driver version: mysql-connector-java-8.0.27 (Revision: ...)
JDBC major version: 4
JDBC minor version: 2

Driver Name: Oracle JDBC Thin client-side driver
------------
Driver JAR File: ojdbc6.jar
Vendor: Oracle
JDBC Type: Type 4
JDK Tested: 1.8
Server name: Oracle
Server version: Oracle Database 11g Release 11.2.0.2.0 - Proion
Driver name: Oracle JDBC driver
Driver version: 11.2.0.4.0
JDBC major version: 11
JDBC minor version: 2

Driver Name: Miscrosoft JDBC Driver
------------
Driver JAR File: mssql-jdbc-7.4.1.jre12.jar
Vendor: Miscrosoft
JDBC Type: Type 4
JDK Tested: 13
Server name: Microsoft SQL Server
Server version: 11.00.3128
Driver name: Microsoft JDBC Driver 7.4 for SQL Server
Driver version: 7.4.1.0
JDBC major version: 4
JDBC minor version: 3

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

 Installing and Running Java DB - Derby

 Derby (Java DB) JDBC Driver

 Derby (Java DB) JDBC DataSource Objects

 Java DB (Derby) - DML Statements

 Java DB (Derby) - ResultSet Objects of Queries

 Java DB (Derby) - PreparedStatement

 MySQL Installation on Windows

 MySQL JDBC Driver (MySQL Connector/J)

 MySQL - PreparedStatement

 MySQL - Reference Implementation of JdbcRowSet

 MySQL - JBDC CallableStatement

 MySQL CLOB (Character Large Object) - TEXT

 MySQL BLOB (Binary Large Object) - BLOB

 Oracle Express Edition Installation on Windows

 Oracle JDBC Drivers

 Oracle - Reference Implementation of JdbcRowSet

 Oracle - PreparedStatement

 Oracle - JBDC CallableStatement

 Oracle CLOB (Character Large Object) - TEXT

 Oracle BLOB (Binary Large Object) - BLOB

 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

 JDBC-ODBC Bridge Driver - MS SQL Server

Summary of JDBC Drivers and Database Servers

List of Tested JDBC Drivers

 Connection URL Formats and Examples

 Implementations of the DataSource Interface

 Performances on Inserting Rows

 Using Connection Pool with JDBC

 Archived Tutorials

 References

 Full Version in PDF/EPUB