view README @ 305:f33401ea2a6c

Artifact database: Refactorized the usage of dialect independent SQL to be reusable. artifacts/trunk@2412 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 28 Jul 2011 10:19:35 +0000
parents aa9f2f5ff032
children 48d14cf857db
line wrap: on
line source

Create a new H2 database for usage in the artifact database:

$ mkdir testdb

$ for i in h2-1.3.152 artifact-database-1.0-SNAPSHOT artifacts-common-1.0-SNAPSHOT log4j-1.2.14 ; do
>    export CLASSPATH=$CLASSPATH:`find ~/.m2/ -name $i.jar`
> done

$ java org.h2.tools.RunScript \
>    -url jdbc:h2:`readlink -f testdb`/artifacts.db \
>    -script artifact-database/doc/schema-h2.sql

http://dive4elements.wald.intevation.org