Linux Apache Derby Getting Started Guide

April 24, 2019 | By thelinuxevangelist | Filed in: Tutorial.

Linux Derby DB Getting Started Guide

The Tutorial Shows You Step-by-Step How to Getting-Started with the Apache Derby Java Database Hello-World on GNU/Linux.

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

Linux Apache Derby Getting Started Guide - Featured
  1. How to Install Derby Database on Linux:

    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

Tags: , , ,