Linux Ubuntu Derby DB Quick Start Guide
How to Getting Started with the Apache Derby Java Database Hello World on Ubuntu 14.04 Trusty Tahr LTS.
Apache Derby, an Apache DB subproject, is an Open Source Relational Database implemented entirely in Java.

-
How to Install Derby Database on Ubuntu
-
Creating a Derby DB and Running SQL Statements.
-
Run Derby ij Tool.
java -jar $DERBY_HOME/lib/derbyrun.jar ij
-
Create and Open Connection to Derby DB.
CONNECT 'jdbc:derby:mydb;create=true';
-
Create the Hello World Table.
CREATE TABLE HELLOWORLD (ID INT PRIMARY KEY, CITY VARCHAR(20), NAME VARCHAR(12));
-
Insert Values into Hello World Table.
INSERT INTO HELLOWORLD VALUES (1,'ROMA','MARIO'),(2,'LOSANGELES','BOB'),(4,'PARIS','JACQUES');
-
Query Hello World Database.
SELECT * FROM HELLOWORLD;
-
-
Apache Derby Database Online Documentation