Thursday, July 1, 2010

Setting-up and accessing Derby DB in Ubuntu

1. Download Derby bin distribution from here.

2. Extract it.

3. Set DERBY_HOME and add it to the path.
vi ~/.bashrc

Add as below;
export DERBY_HOME=/opt/software/db-derby-10.3.1.4-bin
export PATH=$PATH:$DERBY_HOME/bin

Then source bashrc
source ~/.bashrc


4. Run $DERBY_HOME/bin/startNetworkServer.sh
sh startNetworkServer

5. To use ij tool;
set DERBY_OPTS=-Dij.protocol=jdbc:derby://localhost/

Then type ij on the prompt to get the ij tool, where u can type in commands.


1 comment:

Day 03 Gala Dinner Highlight Video