Quick Start with Apache Derby

Download and Install Derby

  • Download the Apache Derby database.
    Note: At the time of this post, I am using version 10.10
  • To install, simply unpack the download to your favorite directory. We’ll refer to this directory as $DERBY_HOME

Start Derby server

  • $DERBY_HOME/bin/startNetworkServer

Connect to Derby

  • Run Derby’s interactive SQL tool: $DERBY_HOME/bin/ij
  • ij>connect ‘jdbc:derby://localhost:1527/sample-db;create=true;user=APP;password=APP’;
    Note: This command will connect to the Derby server running on localhost on Derby’s default port, 1527. create=true will create a database named ‘sample-db’ if ‘sample-db’ does not already exist. We will connect to Derby using Derby’s default user, APP with password APP.

Create a sample table

  • ij>CREATE TABLE SAMPLE_TABLE (SAMPLE_ID BIGINT GENERATED BY DEFAULT AS IDENTITY NOT NULL, SAMPLE_FIELD VARCHAR(255), PRIMARY KEY (SAMPLE_ID));

Insert a record

  • ij>INSERT INTO SAMPLE_TABLE VALUES(default, ‘sample value’);

Query all records

  • ij>SELECT * FROM SAMPLE_TABLE;

Next steps…

You’ve just learned some Derby and SQL basics! You can now connect to Derby, create a database, create a table, insert records, and run a query . Perhaps, it’s time to dive a bit deeper. For more information on ij and Derby, you might consider a  visit to http://db.apache.org/derby/.

Thank you!

You may also like...

Leave a Reply