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

December 18, 2014 | By the+gnu+linux+evangelist.

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.

Quick-Start with Apache Derby for Ubuntu 14.04 Trusty LTS - Featured
  1. How to Install Derby Database on Ubuntu

    Derby DB Install Guide
  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

QuickChic Theme • Powered by WordPress