How to set H2 DB URL with Geonetwork 4.2

[eblondel]

Dear Geonetwork team,

We are currently upgrading a Geonetwork to 4.2, with a start from scratch (publishing back all metadata using the API) with no DB recovery. We would like to stick (for now) with the H2 database. However we struggle to configure the H2 settings.

We could configure well the data sdirectory location with JAVA_OPTS, but the setting below for H2 has no effect:

JAVA_OPTS="-server -Xms1g -Xmx2g -Djava.awt.headless=true -Dgeonetwork.dir=$GEONETWORK_DATA_DIR -Dgeonetwork.db.type=h2 -Djdbc.database=$GEONETWORK_DATA_DIR -Dgeonetwork.db.url=jdbc:h2:$GEONETWORK_DATA_DIR
-Dgeonetwork.db.username=geo -Dgeonetwork.db.password=network -Dgeonetwork.fileStorageDir=$FILE_STORAGE_DIR -Dgeonetwork.metadataStorageDir=$METADATA_STORAGE_DIR"

The default H2 database keep getting stored to home directory /home/<user>, and the gn.mv.db is used by default.

Could you please advise how to solve this?

[ianwallen]

The database location in H2 database is based on the db.name property

core-geonetwork/pom.xml

Line 1474 in 41b227e

<db.name>#{systemEnvironment['GEONETWORK_DB_NAME']?:'~/gn'}</db.name>

the db.name is assigned to jdbc.database

core-geonetwork/web/src/main/webResources/WEB-INF/config-db/jdbc.properties

Line 26 in 41b227e

jdbc.database=${db.name}

And then used in the h2 configuration

core-geonetwork/web/src/main/webResources/WEB-INF/config-db/h2.xml

Line 43 in 41b227e

value="jdbc:h2:${jdbc.database};NON_KEYWORDS=VALUE;${jdbc.connectionProperties:LOCK_TIMEOUT=20000;DB_CLOSE_ON_EXIT=FALSE}"/>

You can override the default value by setting an environment variable GEONETWORK_DB_NAME equal to the location you want to store it. This is how I normally do it. But it may also be possible to set the db.name or jdbc.database properties in JAVA_OPTS but I have not tried.