Apache Derby Quick-Start on Ubuntu 14.04 Trusty LTS 32-64bit Linux Easy Guide

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 i386/amd64.

Apache Derby, an Apache DB subproject, is an Open Source Relational Database implemented entirely in Java.

1. How to Install Derby Database on Ubuntu

   Derby DB Install Guide

   Derby DB Setup

2. Creating a Derby DB and Running SQL Statements.

   1. Run Derby ij Tool.

      java -jar $DERBY_HOME/lib/derbyrun.jar ij

   2. Create and Open Connection to Derby DB.

      CONNECT 'jdbc:derby:mydb;create=true';

   3. Create the Hello World Table.

      CREATE TABLE HELLOWORLD
      (ID INT PRIMARY KEY,
      CITY VARCHAR(20),
      NAME VARCHAR(12));
      

   4. Insert Values into Hello World Table.

      INSERT INTO HELLOWORLD VALUES 
      (1,'ROMA','MARIO'),(2,'LOSANGELES','BOB'),(4,'PARIS','JACQUES');
      

   5. Query Hello World Database.

      SELECT * FROM HELLOWORLD;

3. Apache Derby Database Online Documentation

   Apache Derby DB Docs

   Derby DB Docs