home.


Tagged: derby-setup


Apache Derby setup and ij usage

First download Apache Derby from its website. And put the both to the unzipped folder in your environment, including your PATH.

    export DERBY_HOME = /your/path
    export PATH=$PATH:$DERBY_HOME/bin

You also need to set the derby property to say the database is on localhost for the ‘ij’ property:

    export DERBY_OPTS=-Dij.protocol=jdbc:derby://localhost/

Now you should be able to run the ‘ij’ program. Exit it via issuing ‘quit;’.

Open up ij, and create a new database:

    ij> CONNECT 'jdbc:derby:firstdb;create=true';

In the current directory you’ll have a firstdb/ directory. This constitutes the database. Don’t touch the files within!

You can then create a new simple table, insert a value and print the table using the following usual SQL:

    ij> create table one (text varchar(500));
    0 rows inserted/updated/deleted
    ij> insert into one values ('hello');
    1 row inserted/updated/deleted
    ij> select * from one;
    TEXT                                                                                                                            
    --------------------------------------------------------------------------
    hello

Since ij doesn’t have a command history, you may want to issue the commands from the command line instead:

    $ echo "connect 'jdbc:derby:firstdb'; select * from one;" | ij
    ij version 10.10
    ij> ij> TEXT                                                                                                                            
    --------------------------------------------------------------------------
    hello                                                                                                                           

    1 row selected

Note we are using the embedded version of Derby. You can access the same database simultaneously. My other post on the network server will help you there.

derby derby-setup

Page 1 of 1