Quick guide to using the Derby database server.
Download Derby from http://db.apache.org/derby/derby_downloads.html.
Unzip the downloaded file in a folder. We will call the folder <DERBY>.
From the <DERBY>/bin folder, start the network server:
./startNetworkServer -h IP_ADDRESS
Where IP_ADDRESS is the address of the machine where Derby is running. This option will let a remote client connect to Derby. For example:
./startNetworkServer -h 192.168.71.96
Verify that the server is running:
./NetworkServerControl sysinfo -h 192.168.71.96
Connect to Derby using ij and do some work.
Enter this command to connect to a database:
This will create a folder called MyDB under <DERBY>/bin and create a database there.
Create a table:
create table DUMMY (ID integer PRIMARY KEY, NAME char(128));
View the schema of the new table:
Finish up work.
Shutdown the server:
./stopNetworkServer -h 192.168.71.96