Ubuntu 14.04 Trusty Derby DB Quick Start
Hi! The Tutorial shows you Step-by-Step How to Install and Getting-Started with the Apache Derby Java Database on Ubuntu 14.04 Trusty Tahr LTS i386/amd64 Desktop/Server.
Apache Derby, an Apache DB subproject, is an Open Source Relational Database implemented entirely in Java.
Apache Derby main Features List:
- Small Footprint
- Based on Java, JDBC and SQL Standards
- Embedded JDBC Driver to Easy Integrate in Java Projects
- Support the Client/Server Mode with Derby Network Client JDBC
- Easy to Install, Deploy and Use
-
Download the Latest Apache Derby Database Release
-
Double-Click on Archive
Extract into /tmp.
Or from Command Line:tar xvzf $HOME/Downloads/db-derby*.bin.tar.gz -C /tmp/
-
Open a Command Line Console Window
Ctrl+Alt+t
(Press “Enter” to Execute Commands)
In case first see: Terminal QuickStart Guide.
Or Login into Server Shell Shell. -
Setting Derby Ownership.
sudo su -c "chown -R root:root /tmp/db-derby*"
-
Relocating Derby Folder.
sudo su -c "mv /tmp/db-derby* /opt/db-derby"
-
Setting Derby Environment Variables
nano $HOME/.bashrc
Append:
/nexport DERBY_HOME=/opt/db-derby/nexport PATH=$PATH:$DERBY_HOME/bin
Ctrl+x to Save &exit; from nano Editor :)
bash
To Load new Setup
-
How to Install Required Oracle Java JDK on Ubuntu
-
Getting-Started with Derby Database on Ubuntu