Linux Apache Derby Getting Started Guide

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 – Step by step Tutorial.

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

1. How to Install Derby Database on Linux

   Derby DB Install Guide

   Derby DB Linux 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