Derby (Java DB) in the JDK 1.8 Package

This section describes how to use Derby (Java DB) 10.11 that included in JDK 1.8 package.

Derby (Java DB) 10.11 free version is now included in the JDK package. If you have already downloaded and installed JDK 1.8, the Derby is available in the %JAVA_HOME%\db folder. There is no need to download and install Derby separately. For example, on my Windows computer, I have JDK 1.8.0_45 installed. The Derby is located at "C:\Program Files\Java\jdk1.8.0_45\db\".

Now set the DERBY_HOME environment variable:

herong> set DERBY_HOME=C:\Program Files\Java\jdk1.8.0_45\db"

If you haven't installed JDK 1.8 yet. Please follow the JDK 1.8 download and installation tutorial presented earlier in this book.

If you have an old version of Derby (Java DB) installed, you should remove the old version and remove related environment variables. For example, I have Derby (Java DB) 10.5.3 installed. So I need to remove the "C:\Program Files\Sun\JavaDB" folder.

Table of Contents

 About This Book

 JDBC (Java Database Connectivity) Introduction

 JDK (Java SE) Installation

Installing and Running Derby (Java DB)

 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

 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