Summary of JDBC Drivers and Database Servers

JDBC Tutorials - Herong's Tutorial Examples

∟Summary of JDBC Drivers and Database Servers

This chapter provides a quick summary of JDBC drivers for different database servers. Topics include list of JDBC drivers and their JAR files; list of database connection URL formats; list of DataSource implementation classes; performance comparison of different insert methods.

List of Tested JDBC Drivers

Connection URL Formats and Examples

Implementations of the DataSource Interface

Performances on Inserting Rows

Takeaways:

Derby JDBC driver 10.2.2.0 for Derby server supports the latest JDBC API 4.2.
MySQL Connector J driver seems to have the best performance on inserting rows.

Note that JDBC tutorials for other database servers are moved the following books:

JDBC for MySQL - Herong's Tutorial Examples, Herong Yang, https://www.herongyang.com/JDBC-MySQL/
JDBC for Oracle - Herong's Tutorial Examples, Herong Yang, https://www.herongyang.com/JDBC-Oracle/
JDBC for SQL Server - Herong's Tutorial Examples, Herong Yang, https://www.herongyang.com/JDBC-SQL-Server/

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Installing and Running Derby (Java DB)

Derby (Java DB) JDBC Driver

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

Using Connection Pool with JDBC

Archived Tutorials

References

Full Version in PDF/EPUB