Setting up Apache Derby

Software Requirements

Install Java 1.6 or higher.

Below step-by-step procedure explains how to set up Derby in your machine.

Step 1: Download Derby.

Go to below location and get the latest version of the Derby.

https://db.apache.org/derby/derby_downloads.html

At the time of writing this post, ‘10.13.1.1’ is the latest version.

Step 2: Set ‘DERBY_HOME’ variable.

Extract the downloaded zip file from step1.

set DERBY_HOME environment variable to the root directory of the Derby installation (Extracted Location).

For example

I extracted Derby to the localtion, 'C:\Users\Krishna\Documents\Study\Apache Derby\Software\db-derby-10.13.1.1-bin'. So the environment variable DERBY_HOME should set to the value 'C:\Users\Krishna\Documents\Study\Apache Derby\Software\db-derby-10.13.1.1-bin'.

How to set DERBY_HOME in Windows?

Right click on my computer -> Properties.

Click on ‘Advanced Settings’.

Go to ‘Advanced’ tab and click on ‘Environment Variables’.

Click on New button under ‘System Variables’ section.

Give the name as ‘DERBY_HOME’ and value as, the path where you extracted the derby. For ex: I given as

‘C:\Users\Krishna\Documents\Study\Apache Derby\Software\db-derby-10.13.1.1-bin’

That’s it, you are done.

Verify whether DERBY_HOME set properly or not.

Open new command prompt and type echo %DERBY_HOME’. If you got the value that you set previously, then you are done.

Add %DERBY_HOME%/bin to system path.

Setting DERBY_HOME in Linux Environment

Korn and bash shells:

export DERBY_HOME=derby-install-dir

Bourne shell:

DERBY_HOME=derby-install-dir

export DERBY_HOME

C shell:

setenv DERBY_HOME derby-install-dir

Add bin directory of Derby to system path.

Previous                                                 Next                                                 Home