Linux Ubuntu Derby DB Quick Start Guide
Hi! The Tutorial shows you Step-by-Step How to Getting-Started with the Apache Derby Java Database Hello World on Ubuntu 14.04 Trusty Tahr LTS i386/amd64.
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