Configure the DBMS

Geostore use an H2 in-memory DB as default DBMS for persist the data. This configuration is usefull for develop, test and evaluate the project but is obviously NOT RECOMMENDED for production usage.

For other DBMS usage you have to compile the project with specified profile for the specified DBMS you want to use, then the needed dependencies and a configuration file for the connection are loaded.

In webapp module under src/main/resources/db-conf there are the configuration files for all DBMS supported. You can edit the file you want and, at compilation time, that file will copied in src/main/resources and will be used for the configuration.

Actually the only other DBMS supported are PostgreSQL and Oracle and you can compile with these supports launching this Maven command:

mvn clean install -Dovrdir=postgres -Ppostgres

or

mvn clean install -Dovrdir=oracle -Poracle

Under the path geostore/src/server/web/app/src/main/resources/db-conf you can find the properties file that contains the configuration for the selected db. Be carefull when modify that properties.

For Developers: you can override the default config loaded by jetty by changing the file src\core\persistence\target\test-classes\postgres\geostore-datasource-ovr.properties