Derby (Java DB) JDBC Driver

JDBC Tutorials - Herong's Tutorial Examples

∟Derby (Java DB) JDBC Driver

This chapter provides tutorial notes on the JDBC driver for Derby (Java DB) produced by Apache. Topics include loading JDBC driver classes; connecting Derby Network Server; getting JDBC driver information; creating tables and running queries through the Derby JDBC driver.

Derby (Java DB) Driver Features

Loading Derby JDBC Driver Classes

Creating Connections to Derby (Java DB) Network Server

Derby (Java DB) Network Server and JDBC Driver Info

Derby (Java DB) - Creating New Tables

Derby (Java DB) - Inserting Data Rows to Existing Tables

Derby (Java DB) - Running SELECT Queries

Takeaways:

The latest version the JDBC driver for the Derby (Java DB) Server is included in the Derby server package, which can be downloaded from Apache Derby Website.
If you are still using JDK 1.7 or 1.8, the JDBC driver for the Derby (Java DB) Server is included in the JDK package located at %JAVA_HOME%\db\lib\derbyclient.jar.
The JDBC driver for the Derby Server supports JDBC 4.2.
The connection URL for the Derby JDBC driver is "jdbc:derby://[host][:port]/[TestDB]".

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