JDBC Tutorials - Herong's Tutorial Examples - v3.14, by Herong Yang
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: 21 Server name: Apache Derby Server version: 10.17.1.0 - (1913217) Driver name: Apache Derby Network Client JDBC Driver Driver version: 10.17.1.0 - (1913217 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: 17 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: ojdbc11.jar Vendor: Oracle JDBC Type: Type 4 JDK Tested: 17 Server name: Oracle Server version: Oracle Database 21c Express Edition Release 21.0.0.0.0 Version 21.3.0.0.0 Driver name: Oracle JDBC driver Driver version: 21.4.0.0.0 JDBC major version: 4 JDBC minor version: 3 Driver Name: Miscrosoft JDBC Driver ------------ Driver JAR File: mssql-jdbc-9.4.1.jre16.jar Vendor: Miscrosoft JDBC Type: Type 4 JDK Tested: 17 Server name: Microsoft SQL Server Server version: 15.00.2000 Driver name: Microsoft JDBC Driver 9.4 for SQL Server Driver version: 9.4.1.0 JDBC major version: 4 JDBC minor version: 3
Table of Contents
JDBC (Java Database Connectivity) Introduction
Installing and Running Derby (Java DB)
Derby (Java DB) JDBC DataSource Objects
Derby (Java DB) - DML Statements
Derby (Java DB) - ResultSet Objects of Queries
Derby (Java DB) - PreparedStatement
►Summary of JDBC Drivers and Database Servers
Connection URL Formats and Examples
Implementations of the DataSource Interface
Performances on Inserting Rows