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

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