view backend/contrib/dump-schema.sh @ 8470:c5a7aae52396

Added a validation SQL query to database backends. Enable it by storing something like "SELECT 1 FROM DUAL" in config under /artifact-database/backend-database/validation-query/text() or /artifact-database/seddb-database/validation-query/text().
author Sascha L. Teichmann <teichmann@intevation.de>
date Wed, 12 Nov 2014 13:31:53 +0100
parents 5aa05a7a34b7
children
line wrap: on
line source
#!/bin/bash

DB_URL=jdbc:postgresql://czech-republic.atlas.intevation.de:5432/flys3
DB_USER=flys
DB_PASS=flys
DB_DIALECT=org.hibernatespatial.oracle.OracleSpatial10gDialect

mvn compile package -e \
    -Dlog4j.configuration=file://`readlink -f contrib/log4j.properties` \
    -Dflys.backend.user=$DB_USER \
    -Dflys.backend.password=$DB_PASS \
    -Dflys.backend.dialect=$DB_DIALECT \
    -Dflys.backend.url=$DB_URL \
    -Dexec.mainClass=de.intevation.flys.App \
    exec:java

http://dive4elements.wald.intevation.org