Note: 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

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.

Install “Druid” a database management program available at http://sourceforge.net/projects/druid

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

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

Start Druid

From the "config" menu select "jdbc drivers" and press the "new" button located in the dialog that pops up. Now select the "mkjdbc.jar" file inside the web/WEB-INF/lib directory to add it to the system.

Now, 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.