[GeoNetwork-devel] navigate geonetwork H2 DB

GeoNetwork GeoNetwork Developer
1

Hi,

I’m trying to get inside an H2 DB generated on startup by geonetwork. I’ve tried several tools (squirrel SQL, SQL workbench). I manage to connect, but It looks as though the database were completely empty. I can’t see any table, and then of course, no data.

What am I doing wrong ? Any idea ?

Thanks,

Jean

2

What version of geonetwork are you using?

···

On Thu, May 15, 2014 at 8:02 PM, Jean Pommier - PI geosolutions <jean.pommier@anonymised.com> wrote:

Hi,

I’m trying to get inside an H2 DB generated on startup by geonetwork. I’ve tried several tools (squirrel SQL, SQL workbench). I manage to connect, but It looks as though the database were completely empty. I can’t see any table, and then of course, no data.

What am I doing wrong ? Any idea ?

Thanks,

Jean

“Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free.”
http://p.sf.net/sfu/SauceLabs

GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

3

Oh. Sorry.

Geonetwork 2.10.x

···

On Thu, May 15, 2014 at 8:02 PM, Jean Pommier - PI geosolutions <jean.pommier@anonymised.com> wrote:

Hi,

I’m trying to get inside an H2 DB generated on startup by geonetwork. I’ve tried several tools (squirrel SQL, SQL workbench). I manage to connect, but It looks as though the database were completely empty. I can’t see any table, and then of course, no data.
What am I doing wrong ? Any idea ?
Thanks,

Jean

“Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free.”
http://p.sf.net/sfu/SauceLabs

GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

4

I imagine you have probably looked, but check again in the config.xml file and maybe change the h2 url to be an explicit path to make sure you are checking the same one that geonetwork is using.

Also try running geonetwork and then shut it down before looking in the database.

The data is usually put in the public schema.

Jesse

···

On Thu, May 15, 2014 at 8:23 PM, Jean Pommier - PI geosolutions <jean.pommier@anonymised.com> wrote:

Oh. Sorry.

Geonetwork 2.10.x

Le 2014-05-15 20:14, Jesse Eichar a écrit :

What version of geonetwork are you using?

On Thu, May 15, 2014 at 8:02 PM, Jean Pommier - PI geosolutions <jean.pommier@anonymised.com> wrote:

Hi,

I’m trying to get inside an H2 DB generated on startup by geonetwork. I’ve tried several tools (squirrel SQL, SQL workbench). I manage to connect, but It looks as though the database were completely empty. I can’t see any table, and then of course, no data.
What am I doing wrong ? Any idea ?
Thanks,

Jean

“Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free.”
http://p.sf.net/sfu/SauceLabs

GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

5

Hi Jesse,

Thanks for the help.

I finally found what I did wrong : in the driver setup, I was writing geonetwork.h2.db, while I needed to write it without the .h2.db extension. Thus, it created a new DB named geonetwork.h2.db.h2.db. That was obviously empty.

Can’t believe I spent more than 1h on such a dumb thing !

Thanks,

Jean

···

On Thu, May 15, 2014 at 8:23 PM, Jean Pommier - PI geosolutions <jean.pommier@anonymised.com> wrote:

Oh. Sorry.

Geonetwork 2.10.x

Le 2014-05-15 20:14, Jesse Eichar a écrit :

What version of geonetwork are you using?

On Thu, May 15, 2014 at 8:02 PM, Jean Pommier - PI geosolutions <jean.pommier@anonymised.com> wrote:

Hi,

I’m trying to get inside an H2 DB generated on startup by geonetwork. I’ve tried several tools (squirrel SQL, SQL workbench). I manage to connect, but It looks as though the database were completely empty. I can’t see any table, and then of course, no data.
What am I doing wrong ? Any idea ?
Thanks,

Jean

“Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free.”
http://p.sf.net/sfu/SauceLabs

GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork