annotate README @ 43:b8516aa3d8a1

Time delta calculation in SQL statement to figure out outdated artifacts in H2 database was broken. artifacts/trunk@122 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Thu, 24 Sep 2009 09:15:56 +0000
parents 88972c6daa4f
children 9449f296cd54
rev   line source
3
b1ec257e9d8d Added dependencies to H2 and restlet.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 0
diff changeset
1
b1ec257e9d8d Added dependencies to H2 and restlet.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 0
diff changeset
2 Create a new H2 database for usage in the artifact database:
b1ec257e9d8d Added dependencies to H2 and restlet.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 0
diff changeset
3
30
88972c6daa4f Added a cleanup thread which periodically removes
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 3
diff changeset
4 $ java -cp `find ~/.m2/ -name h2\*.jar` org.h2.tools.RunScript \
3
b1ec257e9d8d Added dependencies to H2 and restlet.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 0
diff changeset
5 -user USER \
b1ec257e9d8d Added dependencies to H2 and restlet.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 0
diff changeset
6 -password PASSWORD \
30
88972c6daa4f Added a cleanup thread which periodically removes
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 3
diff changeset
7 -url jdbc:h2:artifact-database/doc/example-conf/artifacts.db \
88972c6daa4f Added a cleanup thread which periodically removes
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 3
diff changeset
8 -script artifact-database/doc/schema.sql

http://dive4elements.wald.intevation.org