Differences

This shows you the differences between two versions of the page.

--- apache_derby [2016/03/05 13:49] – created skip
+++ apache_derby [2020/12/27 20:35] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== Apache Derby ======
+A tiny Java DB (2MB) deliered togehter with JDK.
+== install ==
+set environment var DERBY_HOME
+<code>
+DERBY_HOME=d:\path\to\jdk8x64\db\
+</code>
+and add DERBY_HOME\bin to Path environment variable
+== start derby ==
+<code>
+$DERBY_HOME/bin/startNetworkServer
+</code>
+== create Database ==
+Start queriing tool **ij**
+<code>
+ij
+</code>
+Create DB by connecting to it with **create=true**
+<code>
+ij> connect 'jdbc:derby://localhost:1527/Chapter01DB;create=true';
+</code>
+Create **customer** Table
+<code>
+ij> create table customer (custId int primary key, firstname varchar(20), lastname varchar(20));
+</code>
+Print **customer** Table
+<code>
+ij> describe customer;
+</code>
+Insert stuff into **customer** Table
+<code>
+ij> insert into customer values (1, 'Fred', 'Chene');
+ij> insert into customer values (2, 'Sylvain', 'Verin');
+ij> insert into customer values (3, 'Robin', 'Riou');
+</code>
+Count stuff in **customer** Table
+<code>
+ij> select count(*) from customer;
+</code>