Installing and Running Derby (Java DB)

JDBC Tutorials - Herong's Tutorial Examples

∟Installing and Running Derby (Java DB)

This chapter provides tutorial notes on downloading, installing and setting up Derby (Java DB) server. Topics include downloading and installing Java DB 10.5.3; verifying Java DB execution environment; running Java DB in Network Server mode; using 'ij' to create database and tables.

Downloading and Installing Derby (Java DB)

Derby (Java DB) in the JDK 1.8 Package

Downloading Derby (Java DB) Documents

"sysinfo" - Checking Derby (Java DB) Installation

Setting Up Derby (Java DB) in Network Server

"ij" - Client Tool to Create New Databases

Takeaways:

Derby (also called Java DB) is open source database server developed by Apache.
Newer versions of JDK packages do not include Derby package. You need to download and install Derby from Apache Derby Website.
Derby 10.11 was included in the JDK 1.8 Windows package.
"ij" is a command line interface that allows you to manage a Derby server remotely.

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