Downloading and Installing Java DB (Derby)

JDBC Tutorials - Herong's Tutorial Examples

∟Downloading and Installing Java DB (Derby)

This section describes how to download and install Java DB (Derby database server) 10.11 - free for evaluation.

Java DB is a relational database management system that is based on the Java programming language and SQL. Java DB is a commercial release of the Apache Software Foundation's (ASF) open source relational database project. But you can still download a copy of Java DB free for evaluation. The Apache project is called Derby.

If you want to install the latest version of Derby, you can follow this tutorial:

1. Go to Apache Derby Website at https://db.apache.org/derby/.

2. Click "Download" from the menu. You see the list of Derby versions for downloading.

3. Click "10.15.1.3" to see the download option page.

4. Click "db-derby-10.15.1.3-bin.zip" to download the binary package in ZIP format, which is good for Windows, Linux and macOS systems.

5. Unzip the download file in a local directory like %HOME%\local\derby or $HOME/local/derby depending your system platform. All installed files will be in the "db-derby-10.15.1.3-bin" sub-directory.

6. Look at installed files:

(on Windows systems)
herong> dir %HOME%\local\derby\db-derby-10.15.1.3-bin

(on Linux or macOS systems)
herong$ ls -l $HOME/local/derby/db-derby-10.15.1.3-bin

47124   KEYS
11560   LICENSE
12966   NOTICE
12616   RELEASE-NOTES.html
(dir)   bin
(dir)   demo
(dir)   docs
 4993   index.html
(dir)   javadoc
(dir)   lib
(dir)   test

7. Setting environment variables to help running Derby. For example:

(on Windows systems)
herong> set JAVA_HOME=C:\Program Files\Java\jdk-12.0.1
herong> set DERBY_HOME=%HOME%\lib\db-derby-10.15.1.3-bin

(on CentOS Linux systems)
herong$ export JAVA_HOME=/usr/lib/jvm/jre-1.8.0-openjdk.i386
herong$ export DERBY_HOME=$HOME/lib/db-derby-10.15.1.3-bin

(on macOS systems)
$ export JAVA_HOME=/Library/Java/JavaVirtualMachines/jdk-13.jdk/Contents/Home
$ export DERBY_HOME=$HOME/lib/db-derby-10.15.1.3-bin