How to access (derby) database directly

Jump to bottom Edit New page

Michal Stekrt edited this page Oct 8, 2013 · 1 revision

This is little quick and dirty howto if you want to look on the data in Compendium database directly via SQL enabled tool.

overview

download sql tool capable of connecting to derby database via jdbc (i.e. squirrelSQL)
download derby ( v 10.10.1.1+) and install it (practically you will need only Apache Derby jdbc driver) unless you want to use ij.
add derby jdbc driver to your squirrelSQL
create connection in squirrelSQL:

jdbc:derby:/home/myusrname/CompendiumNG-prod/data/cngadmindb;create=false

and connect to that database