Personal tools
You are here: Home Documentation Tutorials Website Administration Accessing the McKoi Database with Druid
Document Actions

Accessing the McKoi Database with Druid

This document explains how to set up Druid, an open source database management programme, to connect to the McKoi database.

patrizia

Introduction
Page 5 of 10.


GeoNetwork sets up by default a McKoi database in which the Administration information on Groups, Categories etc. are stored. Moreover the metadata records are stored here. In order to explore the database it is useful to have a database management system of which Druid is an option.

You can use the same procedures to connect to another DBMS you may have selected to use for your GeoNetwork Open Source installation. Connection parameters will be slightly different though.


Druid is a database management program available at http://sourceforge.net/projects/druid.

To install it on you computer please follow the steps below:

1) Stop the webserver on which GeoNetwork is running (Tomcat or Jetty)

2) Start the database by executing in the command prompt:
     C:\Program Files\geonetwork\web\WEB-INF\db>java -jar ../lib/mckoidb.jar

3) Start Druid:
    - From the "config" menu select "jdbc drivers" and press the "new" button located in the dialog that pops up.
    - Select the "mkjdbc.jar" file inside the web/WEB-INF/lib directory to add it to the system.
    - Do a right click on the left panel (the project view) and select "add database".
    - In the dialog that pops up just press "finish".

At this point, on the right panel you should see a set of tabs.

    - Select "jdbc" and then "connection".


If you want to use mckoi insert: url --> jdbc:mckoi://localhost:9157/

Enter the username and password you selected during the installation of geonetwork for the McKoi database. Now press the "connect" button.

Under the tab "structure" you can explore the database.

 
by patrizia last modified 2007-03-14 03:22 Creative Commons - http://creativecommons.org/licenses/by/2.5/

Creative Commons License
This work is licensed under a Creative Commons Attribution-No Derivative Works 3.0 Unported License.

Powered by Plone CMS, the Open Source Content Management System