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

December 18th, 2014 by thelinuxevangelist

Linux Ubuntu Derby DB Quick-Start Guide



The Linux 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
Share on Tumblr

Tags: , , , , , , , , , , , , , , , , , , , , , , , , ,


Comments are disabled